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

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
0
AdaneEvans
Asked:
AdaneEvans
  • 2
  • 2
1 Solution
 
shanesuebsahakarnCommented:
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
0
 
AdaneEvansAuthor Commented:
What if I'm working with more than one table ?
0
 
shanesuebsahakarnCommented:
Then it depends which fields you have entered data into, and the query that you are basing the table on.
0
 
AdaneEvansAuthor Commented:
Thanks a lot.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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