form trouble

[billy101]

i'd like to know how to insert data into one form then the data be split into two diffrent tables. can you help. please.

 

[simongallop]

Get a girl.....or use recordsets

 

[mattstewart]

you can use the expression builder to set the control source of a text box (or combo/list or other such objects) to a feild in a different table other than the one the form is based off of.

 

[Ernie Taylor]

Matt I don't think that will work. You need to use visual basic to update a field on another table not related to the form otherwise you get a #Name# result. The only other way I can think of is by including the second table as a subform (note must be linked by common field with the main table to work)within the main form and using a set value macro if you do not want to use vb. If you decide on this route create a text box in the subform footer and get the value in there first. Then work on the transfer to the correct line.

Alternatively you could use an update query after you are finished with the form to perform this task.