REALLY Dumb Question-

D

David Habercom

I have a form based on a query combining two tables. I cannot edit a single
field. I can't edit in the query or on the form, and I have set every
imaginable "Allow" to Yes and "Data Entry" to Yes. But all I get is NO NO
NO. What obvious detail am I missing? Thanks.
 
D

David

There are a number of things that can cause a form or its underlying query to
be non-updateable.

Take a look at the following Knowledge Base article:

How to troubleshoot errors that may occur when you update data in Access
queries and in Access forms
http://support.microsoft.com/kb/328828/en-us

Hope that helps!

David
 
J

Jerry Whittle

This is often the case. If you don't do things exactly right, a query of two
or more tables is not updateable. In a nutshell you must be joining the
tables from the primary key field in the parent table to a foriegn key field
in the child table. It also really helps if these two tables a linked in the
Relationships window with Referiental Integrity enabled. Also the query can
not use Distinct or be a Totals query. Things like using a function on a
field, say DMax(), will also create problems.

Probably the best way to update such data is not with just a form. Rather
you should use a form and a subform combination. Access will make sure that
the foriegn key fields are populated properly.

For detailed information search Help for "When can I update data from a
query?"
 
Top