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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shelley - 07 Jan 2005 22:52 GMT

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.

Reply to this Message

Van T. Dinh - 08 Jan 2005 04:09 GMT

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.

Signature

HTH
Van T. Dinh
MVP (Access)

> 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.

Reply to this Message