Form not allowing edits

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

Re: Form not allowing edits

On Oct 31, 11:40 pm, Matt wrote:
> 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

Are the join fields in both tables indexed, and is the index unique in
at least one of the tables?

Re: Form not allowing edits

On Nov 1, 12:50 am, helenwhee...@yahoo.com.au wrote:
> On Oct 31, 11:40 pm, Matt wrote:
>
>
>
>
>
> > 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
>
> Are the join fields in both tables indexed, and is the index unique in
> at least one of the tables?- Hide quoted text -
>
> - Show quoted text -


No they werent. That fixed it!!

Thanks!!