Access Form Wont Allow Edits - Microsoft Access Forum


	Back to Access Forum Comments List

Access Form Wont Allow Edits

John Wingard

2 years ago

I have a form that is supposed to be an edit form. I have checked everything I can think to check. whenever I open the form using the buttons designed for it I can not edit anything. I've checked form recordset type, allow edits, the field is not locked but I still keep coming up with nothing. :-(

	Alex Hedley @Reply 2 years ago
What code opens the Form?

	John Wingard OP @Reply 2 years ago
Macro: where condition ="[ContactID]=" & [ContactID], Data mode Edit, Window mode normal

	Kevin Robertson @Reply 2 years ago
Is the form based on a Query? Is the recordset updatable? Not Updateable

	John Wingard OP @Reply 2 years ago
not a query perse. recordset type is dynaset. Record Source: is set to the table then used a query builder to bring int he fields I wanted in the form.

	John Wingard OP @Reply 2 years ago
Records Lock: no locks allow edits: yes

	John Wingard OP @Reply 2 years ago
I just changed it over to VBA and still the same issue.

	Adam Schwanz @Reply 2 years ago
"not a query perse. recordset type is dynaset. Record Source: is set to the table then used a query builder to bring int he fields I wanted in the form. " I'm guessing it's not updateable as Kevin suggested. Try basing it only on the table without the extra fields and see if you can edit.

	John Wingard OP @Reply 2 years ago
Ok, I guess is needed to sleep on it. Lol, I found the issue. The previous form that has the command to open this form somehow accidentally got set to lock all records..... Thank you for the help.

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

Next Unseen