Access: new record button dimmed, allow additions set to Yes. Can.

[Shelley]

On one of my forms I cannot add new records even though the allow additions,
etc., properties are all set to yes. The new record button is dimmed on my
toolbar as well. I can add new records in the datasheet and the two are
linked without referential integrity being inforced.

 

[Van T. Dinh]

1. If your Form uses a Query as the RecordSource, check to make sure the
Query is updateable.

2. If your Query is updateable, check the "Recordset Type" Prperty of the
Form and make sure it is not of "Snapshot" type.