Saving form data to underlying table

D

Dave B

I have a query with reference to 2 tables. This query is used to input data
in a form. There are 4 pieces of data supplied by one table (Employees) and
all else is inputed to the form. When I close the form, the 4 pieces of data
from the 1 table is not saved. The data is displayed properly in the form
however. I can go out and come back into the form and the datea is all
displayed properly. Do I need to do something in the code?
 
J

John W. Vinson

I have a query with reference to 2 tables. This query is used to input data
in a form. There are 4 pieces of data supplied by one table (Employees) and
all else is inputed to the form. When I close the form, the 4 pieces of data
from the 1 table is not saved. The data is displayed properly in the form
however. I can go out and come back into the form and the datea is all
displayed properly. Do I need to do something in the code?
Click to expand...

What's the RecordSource property of the form?

Normally, if you have two tables, you would have a one to many relationship
between them. The best way to handle this situation is to use a Form for the
"one" side of the relationship and a Subform for the "many", rather than
basing the form on a query joining the two tables.

John W. Vinson [MVP]
 
Top