The command or action SAVE RECORD is not available now

  • Thread starter Thread starter Noelle
  • Start date Start date
N

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
 
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)
 
Back
Top