K
Ken McLean
I am using a form for data entry in an Access 2003 project. The back-end data
is on a remote server reached over the internet. The data source for the form
is a table with 3200 records. The form also displays 6 sub-forms which
display data from child tables of the main table.
There is a 3-4 second delay when the user moves from one field to another on
the form after modifying an existing record or entering data for a new
record. During the delay, the status bar below displays a 'Calculating'
message.
The table is not actually updated until the user moves to a different record
so I don't know what Access is 'calculating' when the user is only moving
between fields. Is there any way I can speed up the editing process by
turning off whatever field-level calculating is going on?
is on a remote server reached over the internet. The data source for the form
is a table with 3200 records. The form also displays 6 sub-forms which
display data from child tables of the main table.
There is a 3-4 second delay when the user moves from one field to another on
the form after modifying an existing record or entering data for a new
record. During the delay, the status bar below displays a 'Calculating'
message.
The table is not actually updated until the user moves to a different record
so I don't know what Access is 'calculating' when the user is only moving
between fields. Is there any way I can speed up the editing process by
turning off whatever field-level calculating is going on?