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.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(E-Mail Removed)
www.pcdatasheet.com


"Leslie" <(E-Mail Removed)> wrote in message
news:35EA976B-5C7B-485C-B8A1-(E-Mail Removed)...
>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