asked on Difference between acNewRec and acSaveRecord
Can you explain the difference between acNewRec and acSaveRecord and when they should be used?
Microsoft Access
Last Comment
Frank Freese
ASKER
As I understand this before a record can be created one must execute acNewRec to prepare the record for data.
Once the data has been entered acSaveRecord is executed.
Now, if a record is edited then you would execute acSaveRecord.
The reason for the question is that I had a form with two command buttons. cmdAdd executed the acNewRec and the second command button cmdSave also executed the acNewRecord, yet the data I created was saved? Why was the data saved? I do believe I need to changed cmdSave from acNeeRec to acSave.
Once the data has been entered acSaveRecord is executed.
Now, if a record is edited then you would execute acSaveRecord.
The reason for the question is that I had a form with two command buttons. cmdAdd executed the acNewRec and the second command button cmdSave also executed the acNewRecord, yet the data I created was saved? Why was the data saved? I do believe I need to changed cmdSave from acNeeRec to acSave.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks! as always I do appreciate you.
when you want to save the record use acSaveRecord