Bring data from one table automatically into a form

[jgb]

I have a form and table called “pcinfo-vendor” that the customer enters some date that they need. They also need to pull up some vendor information from a table called “vendorinfo” – Vendor name, Address, City, State, Phone #, FAX # and Email. What I need help with is this – How can I bring up the data from the “vendorinfo” table on to my form called “pcinfo-vendor”? So that the customer does not have to type in - Vendor name, Address, City, State, Phone #, FAX # and Email – each time for every vendor.
I am using MS Access 2010.
Thank for any help,
jgb.

 

[Uncle Gizmo]

One way is to use a combobox and a set of text boxes that display information from the row source in the combobox.