Opening Form Causes Access to Hang Indefinitely RRS feed

  • Question

  • Hello,

    I am creating a mail merge from an access query.  My form has start and end date fields that gets inserted into the query to pull up classes within the range.  If I run the query by entering in the dates to the criteria fields in design view, the query runs quickly.  But if I  edit the query so that the dates are received from the form, opening the form stalls Access.  Any idea why that might be?  Is it because the form has to load all the data from the linked tables I'm using when I open the form? 



    Friday, March 17, 2017 2:51 PM

All replies

  • Why would the form have to load data at all?  Is it not just 2 textboxes for supplying date value to the query?

    What is the SQL syntax of your query bound to the form?

    Daniel Pineault, 2010-2016 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Friday, March 17, 2017 3:01 PM