I have 2 tables. Table A is a shipping form where data is entered and then printed. Table A has a Pickup Company. The field is a Combo box linked to Table B. Table B has Company's names, address, citystate, contact and phone.
The drop down list works great. When I update Table B my list in the FORM from Table A works great.

I want to have Access automatically enter the next 4 fields(address, citystate, contact and phone) in on the FORM - from the company's name given.

The user must then be able to continue to fill out the form with the rest of the information.
I would like the Delivery Company to be able to do exactly the same thing from Table B as well, but there are several other fields as well.

I created a Query which brings up a box asking for a Company name and then gives me the correct fields but this is not connected to the FORM and I don't want a seperate box to enter the Company Name I want the user to be able to use the drop down in the FORM.

Thanks for your time.