• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • Last Modified:

Access 2007 form: How do I get the current record to automatically save when I click on the Next record control.

Access 2007 form: How do I get the current record to automatically save when I  click on the Next record control.
0
wademi
Asked:
wademi
1 Solution
 
lee555J5Commented:
When you change a record, it is marked as dirty. When you move the focus off the dirty record by clicking another record, hitting a next record button, closing a form, and other ways, your change is saved automatically. There is no need to manually save.
Lee
0
 
JezWaltersCommented:
You can force a save in VBA as follows:
DoCmd.RunCommand acCmdSaveRecord

Open in new window

0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now