By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Can't "SaveRecord"

P: n/a
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.

Feb 11 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Feb 11 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.