AdaneEvans
asked on
acSaveRecord
Forgive me but I'm new to Access and I may ask some simple questions.
The command below apparently saves a record; but to where ?
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
please help
The command below apparently saves a record; but to where ?
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
please help
ASKER
What if I'm working with more than one table ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot.
If you don't use that command, any changes you make to the record (or if you add a new record) aren't saved until you close the form or move off that record to another record (and in some other circumstances). The line above can also be replaced with either of these two:
DoCmd.RunCommand acCmdSaveRecord
Me.Dirty = False