RecordSave Coding

[wchernock]

Is there a difference between

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.Close acForm, CurrentForm, acSaveNo

and

DoCmd.Close acForm, CurrentForm, acSaveYes

 

[KeithG]

I believe in the first expression you are saving changes to the record, in the second expression you are saving changes to the form.

 

[rainman89]

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

This is sloppy. boB larson mentioned to me that this should be avoided at all costs. i know its simple to use because its made by access, but i guess it can cause problems in the end.

 

[wchernock]

Thanks. I am using the second piece of code but wanted someone with experience to verify that I was not missing something.

 

[Rich]

DoMenuItem is obsolete and has been for years. When the Access develpment team talk to each other it'll be removed from the Wizards

 

[boblarson]

I believe in the first expression you are saving changes to the record, in the second expression you are saving changes to the form.

Keith is correct, the second expression has to do with saving design changes to the form and has nothing to do with the records in the form.