1 text box control, from two tables

[mike02]

Hey,


I have a multi-table input form. Is it possible to input 1 item in a cbo box, and have it update a field in both tables. IE

enter Product 1 in the combo Box,

enters Table 1

1 (Product1)

Enters Table 2

1 (Product1)



Both tables have the same field name as it is a foreign key..

[June7]

Review https://www.accessforums.net/access/...rms-35814.html

[mike02]

I have the subform setup just like you had stated..... but how to I make the value of one = another? I have always used the Control source when doing that... thanks

[June7]

If this is a form/subform arrangement of related parent and child records, the subform container control will automate saving the foreign key value. Set the subform container control Master/Child Links properties to the PK/FK fields. Set the ControlSource property of textboxes to the PK/FK fields.