Forms take forever to open

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hi there. Using A02 on XP. Saw a post a few weeks ago and
didn't print it, wish I had. Someone asked what could
speed up forms opening and the answer given was to change
some setting that worked even though it didn't seem
related to the problem. Sorry I'm being vague but perhaps
the experts know just what I'm referring to? Thanks in
advance for any illumination...
 
Basic answer: When a form opens it retrieves all the records in the
underlying table or sql statement.

Change your sql statement to retrieve only the records you need.

or

If you are just adding new records then set the form property
dataentry=yes.

Last if this is an ADP project set the maxrecords property equal to
some reasonable number. By default it is set to 10,000 records.

Hope this helps,

Jason
 
Back
Top