acCmdSaveRecord vs RecordSet Edit/Updates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a theory-type question. Can someone explain to me what the difference
is between DoCmd.RunCommand acCmdSaveRecord and saving Recordsets (e.g.
updates, edits, etc.)?

I am having problems with the DoCmd.RunCommand acCmdSaveRecord and am
wondering if I should be using Recordsets for manipulating my Access database
fields in my forms. I would appreciate some overview of these two topics.

Thanks,
Leslie
 
DoCmd.RunCommand acCmdSaveRecord saves ALL changes to a record. Recordset
Edit/Update can selectively save one or more fields (not necessarily All
fields) whether the values of the fields have been changed or not.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query Running From Form 2
looking for a way around a write conflict... 2
Calling DoCmd.RunCommand acCmdSaveRecord, after calling an API function 2
How to explicitly save a record? 1
Updating a form with the most current information 1
Run-time error '3265' 19
Run Time error with Look up Box 11
reference a record on another form 1

Back
Top