Form stopped accepting input

[FJB]

I have been using the same form to input data to a table for several
weeks. This week the form will not accept data. The form is linked to a
query which uses criteria to choose the records for updating. The query
works fine, but the form would allow input (Data entry is set to yes).
It has been working fine and then just stopped. Any ideas? Thanks for
your help.

Frank

 

[Allen Browne]

Frank, I'm not sure if this will work, but open the form in design view, and
open the Properties box.

Looking at the Properties of the form, delete anything in the Filter and
OrderBy properties. In Access 2002 and 2003, it is possible to end up with
values there that refer to the lookup columns of a combo or listbox, with
the result that the form becomes read-only. I will be interested to know if
that is what happened.

If that is not the case, check the other properties, such as AllowEdits
(should be Yes). You could also check on the Locked and Enabled properties
of the controls (should be No and Yes respectively.)

 

[FJB]

I checked all of the properties as you suggested and nothing helps. I
can only guess that the form has become read only. What do you think
would be the result of deleting the current form and re-creating it?
Should the same thing be done to the query that is the source of this
form?

Thanks for your help
Frank

 

[Allen Browne]

Check that the RecordsetType property of the form is Dynaset (not snapshot
or inconsistent updates.)

There is no point deleting the query if you can still update the fields
directly in the query.

Recreating the form might work, but it would be better to understand which
property caused the problem if that's not too difficult. Otherwise you won't
know how to fix it next time you run into the issue.