Input through 3-table form (Problem)

  • Thread starter Thread starter Jim Normile
  • Start date Start date
J

Jim Normile

On occasions I have designed a query based on two related
tables, and then used a form built on the query to pump
data into the two underlying tables
......noproblem.......
However, if I design a query based on three related
tables, the form which I then create from the query will
not allow data input....


I had this problem in the past and solved it.......I think
I had to alter a property of the form.......I just cant
remember the procedure for making the form capable of
accepting the input into a three-table query..

Anybody out there knowhe solution ?????
Thanks in advance

JIm
 
You should first check your query to make sure it is
updateable. Is the "new record" button on the navigation
bar bolded? Will the query let you tab to a blank row? If
not, you will need to rework the query relationships in
order to make it updatable so that the overlying form can
be used to update the tables. This may take some testing
and experimentation on your part.

Hope this helps
 
Back
Top