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

[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

 

[Ken Snell]

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.

 

[Nick Mirro]

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

 

[Nick Mirro]

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

 

[Ken Snell]

Did you make a change in the form's recordsource recently? Add a new field
or table to the query?

 

[Nick Mirro]

OK, it works now. Changed back to 1:1 and now the insurance form accepts
new records, while all form command buttons work again.

 

[Ken Snell]

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.