Form based on a query.

J

julief

I have a form which is based on a query. This is slowing the database down
as it calculates after each update, move to new record etc.
Is there a way (similar to excel F9 key) that will stop the calculation
being made unless the form is refreshed?
 
K

Keith Wilby

julief said:
I have a form which is based on a query. This is slowing the database down
as it calculates after each update, move to new record etc.
Is there a way (similar to excel F9 key) that will stop the calculation
being made unless the form is refreshed?
Click to expand...

What is the calculation? If it's slowing performance then it's likely that
it could be badly coded.

Keith.
www.keithwilby.com
 
J

julief

The form is sitting on a tabbed control on the sub form would this slow
things down?
 
Top