Refresh subforms via Form_Activate is horrible slow

[checkOut]

I have several forms with 3 or 4 subforms.
Now I want to have the data in the subforms uptodate when the form is active.
Now I choose to requery all the subforms in Form_Activate, but this is so slow that I can't believe there's a better way to do this.
Have anyone suggestions to upgrade the speed of the form but also get the subforms uptodate?

Thanx in advance,
Gerard Krijgsman

 

[PHV]

Check that the underlaying queries use properly defined indexes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[checkOut]

THanx for your Reply PH,
Do you have good information documentation for me about indexes. I'm ashamed, but I never use them before..

Greetz
Gerard

 

[henniec]

Something else you can check. In many cases it makes a vast difference in speed.

Go to Tools\Options\General\Name AutoCorrect and uncheck "Track name AutoCorrect Info". Run your application and see if there is any difference. Leave it unchecked.

I think the default is always checked.

Hennie

 

[checkOut]

Thanx for your tip Hennie,
I knew it decrease the speed,
but my results after deselect the option is not much better.
Do you have more tips?
Maybe only the FORM_Activate is false
Is there a faster way to upgrade the refreshing of the subpages?

Greetz,
Gerard

 

[PHV]

Have you tested the underlaying queries for speed ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[henniec]

Follow this link. It will give you useful information regarding the speed of your project.

http://www.granite.ab.ca/access/performancefaq.htm

Thanks,

Hennie

 

[henniec]

Someting else, how do you requery? Do you use VBA or a macro. I was working on a database and used a macro to do this, it not only slowed it down but also for some reason used a lot of memory.

If you use a macro change it to VBA and use the docmd.requery fuction.

Hope this helps.

Hennie