Auto Save/Next Record on field exit

  • Thread starter Thread starter Jay Wilson
  • Start date Start date
J

Jay Wilson

I would like to have a record automatically save when I exit the last field
on a form, have the form cleared and start typing the next record beginning
with the first field on the form.

What code do I need to put in the "on exit" event to make this happening?

Thanks
 
Jay,

Microsoft Access does this automatically--you don't need to code anything. Of course you'll want to test it out to validate it yourself. Just try typing some data in and click your 'Next' button (or whatever button you have). Afterwards, open the database table and just make sure your record was saved accordingly. I actually get this question quite a bit from the users at my workplace. Given their remarks, I frequently create a button with a picture of a floppy disk--the button simply closes the form (but it gives the user the illusion that their action is causing the data to be saved).

Best regards,

Todd


I would like to have a record automatically save when I exit the last field
on a form, have the form cleared and start typing the next record beginning
with the first field on the form.

What code do I need to put in the "on exit" event to make this happening?

Thanks
 
No "expert" here but AFAIK:
If your Tab Index'es are proper (reachable in design view/Properties/Other
tab) and your form is bound to either a table or an updateable query then
once you hit enter on your last field the form would show a blank (new)
record and the previous will be automatically saved once "Enter" or "Tab"
key is hit at the last field. Unless you have placed some code behind the
form to prevent this.

Hope this will help.

Alp
 
Back
Top