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

.

Relevant Pages

  • Re: Form not allowing edits
    ... I have a form that was given to me to fix, so I do not have a ton of ... but I am unable to edit the Parent form data. ... I have tried opening the query that the form is based on and editing ...
    (comp.databases.ms-access)
  • Re: Keeping Tracking of whos adding new data..
    ... Macro to open the form in Add mode, but no edit mode. ... You should be able to use your form query to set the RC criteria to... ... Not sure what you're doing with the TempLue. ... Candia Computer Consulting. ...
    (microsoft.public.access.formscoding)
  • Re: Read Only Form
    ... If the recordsource for the form is a non editable query, ... cannot edit any of the form fields. ... > the JetPack download Microsoft is pushing? ...
    (microsoft.public.access.forms)
  • Re: DB Result Wizard Error
    ... open the hidden folder /_fpclass/ and edit the ... > For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... > to display the new equipment information. ... > is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)
  • Re: Modifying the current record in code
    ... You should be able to modify the current record, ... I think that iterating ... > )) I think the best thing to do is run an update query and the ... >> You should remove the Edit and Update also. ...
    (microsoft.public.access.formscoding)