for loading question

[Junior]

My form contains three subforms and takes about 5 seconds to open
Looking for options to speed up the opening
or
how do i display a message that says
'I'm gathering the data - please be patient'
and then closes when the form opens?

 

[Allen Browne]

There are several things you could do, such as:
- Make sure Name AutoCorrect is off (Tools | Options | General).
- Make sure the SubdatasheetName is set to No in all tables (Properties box,
in Table Design).

Tony Toews has further suggestions in:
Access Performance FAQ
at:
http://www.granite.ab.ca/access/performancefaq.htm