Help with editing fields in a Form

[Guest]

I'm working in Access2000.
I have 3 tables. I have a query which combines the results of all 3 tables.
I have created a form which uses the query result as it's information source.
I am having problems editing. Access will not allow me to edit whilst in the
query or the form. Message is "This recordset is not updateable". I want to
be able to edit and add information whilst in forms. Think this must be
something simple - help!

 

[Bob Howard]

I had the same problem. Access does not permit what you are trying to do my
"merely" entering data in a field dusplaying information from joined tables.

I'm not an expert in this, but I did get it to work. First, I changed the
form so that it was a primary form with two subforms. I link the subforms
with the primary form using the record key that would have been used to
logically join the tables. I split my query into three queries --- one for
the primary form and one for each of the two subforms.

Now when the "form" opens you see all the data logically related as expected
(but by the linking of the forms, not the joining of the tables in a single
query.

I have code in the AfterUpdate event of the data fields to requery the whole
thing.