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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering a form based on a filter on an open form 2
Form based on query with option group 4
Form based on a query 3
How to make a sum of a sub-form on the main form 2
How to update records in Form based on query 1
New records don't display on form with combo box 1
Form Refresh with Shift F9 1
FORM DIED - form based on query no longer opens to correct record 3

Top