"The command or action 'Save Record' isn't available now."

  • Thread starter Thread starter Nick Mirro
  • Start date Start date
N

Nick Mirro

"The command or action 'Save Record' isn't available now."

I'm getting this error following clicking a command button. All buttons in
all forms with this line of code return this error. I can't figure out what
could be causing it. Any idea?

DoCmd.RunCommand acCmdSaveRecord

Nick
 
My guess is that your button is not in the same section as the records...for
example, you have a continuous forms view for a subform, and your button is
on the main form. When you do that, the main form is being told to save its
record, and if it doesn't have one, you'll see the error.

More info please about your form's setup.
 
Thanks for your reply. These buttons all worked up until now. The new
record button on the record selector is dimmed out also.

Actually it doesn't affect all forms, just 3.

Nick
 
The queries for the forms have the new record button dimmed as well, but
this is not the case in the query's underlying tables.

All other queries allow record additions. Could there be index problems or
corruption?

Nick
 
Did you make a change in the form's recordsource recently? Add a new field
or table to the query?
 
OK, it works now. Changed back to 1:1 and now the insurance form accepts
new records, while all form command buttons work again.
 
I am assuming that you made the query nonupdatable when you added the field;
changing back restored the query to updatable status.

Glad it's working now.
 
Back
Top