one form multiple tables

[joecamel9166]

First I'd like to thank everyone on here for the help I've received so far.



I have a receive form to enter in each unit that comes in.
I have 2 tables. A units table and a customer table.
tables have a relationship based on customer number.
on my receive form, I enter basic info about the unit and generate the unitID
also on this form, I would like to be able to select the customer so I can assign the customer number to the units table.
I would like to have a search box to select which customer sent the unit in, and upon this selection, I would like to display all the billing and shipping info on the form.
I tried binding the text boxes to the desired tables, but I get type mismatch error in expression.

Is this possible to do without using a subform?

Thanks!

[alansidman]

Create a Customer Form and then create your Receive Form. Make the Receive form a sub-form of your Customer Form.
Sub forms are the easiest way to do this as one form binds to only one table.

http://www.datapigtechnologies.com/f...subforms1.html

[joecamel9166]

I kinda figured that. Thanks for the conformation.