The command or action SAVE RECORD is not available now

[Noelle]

Hello,

I am using Access 2002 and trying to save a record. I
copied a program from an earlier version (probably Access
97) that used:

DoCmd.DoMenuItem acFormBar, acRecordsMenu,
acSaveRecord, , acMenuVer70

After looking at some documentation it seems like I
should be writing a statement like:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord

or

DoCmd.RunCommand acCmdSaveRecord

But neither command works and I get an error message of:
The command or action SAVE RECORD is not available now.

Would you please tell me what I am doing wrong?

Thanks,
Noelle

 

[david epsom dot com dot au]

You can't typically save the record unless the form
has focus (which means that if fails as you step through
your code).

Also, in A2000, you can't save a record unless it has
changed:
if me.dirty then
docmd.runcommand acCmdSaveRecord
end if

(david)