Cannot update table from form

S

Sokan33

I combined two tables with select query. I use a custom form to update the
tables but when I added a third table; I'm no longer able to enter data into
the fields. Table1 has 1 to many relationship with with Table2. Once I
removed the third table I'm able to update the tables again. I have fields
in the third table I would like to be a seperate tab in my form.

Your help will be appreciated.
 
W

Wayne Morgan

If the query isn't updateable, then the form built on the query won't be
either. What fields do you need from the third table? Do you need to update
those field or just display them? If you only need to display them, try
using DLookup() statements. If you need to update them, you may need to use
a subform with the third table or a query based on it as the Record Source
for the subform. You can place a subform on a tab sheet, if that's what you
want.
 
S

Sokan33

Your advice worked. Thank you!

Wayne Morgan said:
If the query isn't updateable, then the form built on the query won't be
either. What fields do you need from the third table? Do you need to update
those field or just display them? If you only need to display them, try
using DLookup() statements. If you need to update them, you may need to use
a subform with the third table or a query based on it as the Record Source
for the subform. You can place a subform on a tab sheet, if that's what you
want.
Click to expand...
 
Top