Link to home
Start Free TrialLog in
Avatar of AdaneEvans
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
Avatar of shanesuebsahakarn
shanesuebsahakarn
Flag of United Kingdom of Great Britain and Northern Ireland image

It saves it into the table.

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
Avatar of AdaneEvans
AdaneEvans

ASKER

What if I'm working with more than one table ?
ASKER CERTIFIED SOLUTION
Avatar of shanesuebsahakarn
shanesuebsahakarn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks a lot.