Text Box Control Source

[ajs112]

Hi all,



Is there a way I can have a textbox on a form record information to another table besides the one assigned to that form? For instance, If I store order info in a different table than customer contact information, can a text box record the name and contact info in a tluCustomerInfo and not tblOrderinfo? Additionally, is there a way a combo box or text field can record its value into both of these tables?

Thanks guys!

Anthony

[alansidman]

You will need to have a form and a sub form each bound to a separate table. Look at the videos on this page re: sub forms.

http://www.datapigtechnologies.com/AccessMain.htm