Error Message while trying to edit specific field.

[NSC_24]

I created an update query so that, when "edit specific record" is clicked on
the switchboard, the user is taken to a specific record in the main form and
allowed to make edits. However, when I try to change a specific field I get
the error message "microsoft office access cannot apply the filter because
all of the records are locked." I have checked both the form properties as
well as those under the the Access Options button and they are set to "no
locks".

Can anyone help me solve this problem? Perhaps my query or macro is wrong?

Thanks!

 

[Allen Browne]

Suggestions:

1. Open the query itself, and see if you can modify the data there. If not,
you won't be able to modify the data in the form based on the query. This
link contains a list of things to check to understand why the query is
read-only:
http://allenbrowne.com/ser-61.html

2. If the query is editable, check these properties for the form:
Recordset Type Dynaset (NOT inconsistent updates)
Allow Edits Yes
Record Locks No locks

3. Check these properties for the controls:
Enabled Yes
Locked No

4. If the form is a subform, check the parent form's properties as well.

5. Check the locking strategy for your database. In Access 2007, that's
under:
Office Button | Access Options | Advanced
Set Default open mode to Shared.
Set Default record locking to No Locks.
In earlier versions, you find these settings under Tools | Options.

6. It's odd that the error message says you cannot apply a filter, when you
are actually trying to edit the data. Check that you don't have macros or
event procedures that are trying to do something else than you intend.