Autofill (1 Viewer)

[TimjHebert]

I have 2 tables tblcontact and tblinfo.

tblcontact
contactID-PK
Customer
Contact

tblinfo
infoID-PK
PONumber
location

I want to build a form and have a combo box autofill these fields on the form. how can i do this?

Thanks,
Tim

 

[Pat Hartman]

The tables do not seem to be related in any way. If they were, you would join the two tables and use that query as the RecordSource for the form.