Can't "SaveRecord"

[swingingming]

Hi, On the form, I added a command button and used it to save the
current record. I added some error checking before
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Error # is: 2046
Error msg: The command or action "SaveRecord" isn't available now.
I am using Access 2003.

[Allen Browne]

Try replacing it with:
If Me.Dirty Then RunCommand acCmdSaveRecord

Add error handling in case there is a reason the record can't be saved (e.g.
a required field missing, duplicate index, validation rule not met, ...)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"swingingming" <mi******@gmail.comwrote in message
news:11*********************@v45g2000cwv.googlegro ups.com...

Hi, On the form, I added a command button and used it to save the
current record. I added some error checking before
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Error # is: 2046
Error msg: The command or action "SaveRecord" isn't available now.
I am using Access 2003.