Disabling auto save for a form

J

John H W

I have a form that can get identifying data from either of two different
tables (one default table, the other is used only if the info is not in the
default table). If the info is not in either, then the user types in the
appropriate fields (3) before continuing to entering info on the classes
being taken. If we have the case where the id info is typed-in, when the
SAVE command button is pressed, this info is saved to the non-default table.
(I need to keep the info separated in these tables.)

The problem arises when the ID data is typed in and the user forgets to hit
the SAVE command button and the auto-save feature of Access kicks-in (I won't
go into the problems that arise). I need to do one of these things whenever
this situation arises(if ID data is drawn from default table this does not
apply):
1. Activate the On_KeyPressed event function of the Save Command Button
whenever the auto-save feature kicks-in;
2. Display a message when the auto-save kicks-in (telling the user to press
the Save Command Button) and not do the auto-save; or
3. Disable the auto-save feature, letting the info be lost rather that a
partial save. Partial saves blows reports.

Thanks for any information you can give me.

John H W
 

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

Problems adding new record from form / subform 9
How to pass multiple Fields to new Form 2
How to pass multiple Fields to another Form? 7
Code to save table in my form? 1
subform based on external SQL won't requery 1
Data not saving from bound form when control loses focus 1
don't want users to be able to change data unless they have pushed a button 1
Rollback Save Operation... 2

Top