New Record Disabled - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

New Record Disabled

Stephanie Rybicki

4 years ago

I have a form in my DB that is not allowing new records? The form is built off a query.
I have a button on the form to allow access to related info that is built off a separate table. Everything was working correctly yesterday? The only thing I did last night was some minor format changes on the related form. Any suggestions on what may have occurred?

	Adam Schwanz @Reply 4 years ago
Can you still edit records? I was going to suggest Not Updateable

	Stephanie Rybicki OP @Reply 4 years ago
Yes we can edit the records, we just can't add new via the form, the +new is greyed out.

	Kevin Robertson @Reply 4 years ago
Is Allow Additions set to Yes? `Form Properties - Data Tab`

	Stephanie Rybicki OP @Reply 4 years ago
Allow additions is set to yes

	Kevin Robertson @Reply 4 years ago
Can you upload some images please otherwise it's just a guessing game.

	Stephanie Rybicki OP @Reply 4 years ago

	Stephanie Rybicki OP @Reply 4 years ago

	Kevin Robertson @Reply 4 years ago
Are you able to add records when you run the query?

	Kevin Yip @Reply 4 years ago
The .accdb file may be damaged. Create a new .accdb file and import all your tables, forms, queries, etc. to it.

	Kevin Robertson @Reply 4 years ago
Just had a thought. What is the `Recordset Type` set to? It should be `Dynaset`.

	Stephanie Rybicki OP @Reply 4 years ago
No not in the query either. I can from the table. Here is a screen shot of the query

	Stephanie Rybicki OP @Reply 4 years ago

	Stephanie Rybicki OP @Reply 4 years ago
Where would I check Recordset Type?

	Kevin Robertson @Reply 4 years ago
On the Data Tab in the Form Properties. If you can't add a new record in the query it is unlikely to be the problem. There is, however, a Recordset Type property in Queries as well.

	Kevin Robertson @Reply 4 years ago

	Stephanie Rybicki OP @Reply 4 years ago
Thank you for your help, I had a back up copy from yesterday morning, so reverted to it. You must have been right that the file was corrupted.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View