Update Table Using Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several tables within Access 2003 containing various information. I
want to update the information in a Table via a Form. This first attempt was
very successful and gave me great hope for the following Form. The following
Form needed to have information drawn for three separate Tables with the
information only being updated in one of the Tables. I created Relationships
between the three Tables and created a Query whereby the three Tables would
have various fields pulled. Then when creating the Form I selected the Query
as source for the Form. Everything seemed to be going well until I tried to
update the field of one of the Forms. No luck. Even if I select field from
the various Tables directly in the Form, bi-passing the Query it still won't
work. Anyone have any suggestions?
 
Try working with the query itself, without the form.
You may find that the query itself is not updatable.
Once the query is updatable, most likely the form will be, too.
If you get stuck on the query, post the SQL.
 
Dang, you are right the Query itself is not updatable. I'll have to look into
it closer in the morning but why would the Query not be updatable? I guess
I'm missing something, probably simple too. Well, as I said I'll look at it
in the morning. Thank you.
 
Back
Top