'The command or action "RecordsGoToNew" isn't available now'

[jordatf]

Hi,

I placed a button on a form that would duplicate the record. When I clicked on the button, the message 'The command or action "RecordsGoToNew" isn't available now' appeared. I checked the list of commands and RecordsGotoNew is there.

Is this command no longer functional?

 

[ghudson]

is the new record violating any primary keys in the table?

 

[jordatf]

The key for the records is an autonumber, so i don't htink there is a key problem.

I am using Access 2007 running on Vista Home Premium.

 

[SOS]

Is the underlying record source of the form updateable? (can you add a record directly using the query that is the record source of the form)?

Are Allow Additions set to YES?

 

[jordatf]

Allow Additions was set to "No". Thanks for the tip.

 

[SOS]

Glad we could help