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

G

Guest

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

allow additions confuses user 2
Allow Additions Sort Order 3
Allow Additions Ignored 3
Form only allows five records 3
Additions Denied 4
Temporary allow additions? 6
additions-yes, data entry-yes, cannot add new record 9
Add new Records 2

Top