By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,363 Members | 1,708 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,363 IT Pros & Developers. It's quick & easy.

Form not allowing edits

P: n/a
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

Oct 31 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Oct 31, 11:40 pm, Matt <mdw...@gmail.comwrote:
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?

Nov 1 '07 #2

P: n/a
On Nov 1, 12:50 am, helenwhee...@yahoo.com.au wrote:
On Oct 31, 11:40 pm, Matt <mdw...@gmail.comwrote:


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!!

Nov 1 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.