Form not allowing edits

[Matt]

Hi All,

I have a form that was given to me to fix, so I do not have a ton of
background here but I will do my best. Also, my form design
experience is somewhat lacking, so here goes:

Situation:
---------------------------------------
Form has a Parent and Sub form. Strangely enough I can edit the
subform data, but I am unable to edit the Parent form data. All of
the form fields are set to Enabled and Locked is set to no. Also, the
form properties of 'Allow Edits' and 'DataEntry' are both set to yes.


What I have tried:
-----------------------------------------
I have tried opening the query that the form is based on and editing
data directly in the query. It will not let me edit data in this
manner.

I then tried to rebulid the query from scratch, table by table (query
only has 2 tables). When I added the fields from the first table I
could run the query and edit the data, but the moment I joined the
second table in the query I am unable to edit data directly in the
query, which I am guessing is the reason I can not edit it on the
form.

Thanks in advance for any help!
-Matt

 

[Pieter Wijnen]

make sure there's a unique (primary key) index on table 2

Pieter

 

[Matt]

make sure there's a unique (primary key) index on table 2

Pieter











- Show quoted text -

That did the trick!!
Thanks Pieter.