lookup syncronization

[GregJ]

Newbie User...
I have a form with a lookup to a "Company Name" field which works great.
Then I have another field that I want to do a lookup on a contact person, and
I want the Contact lookup to only display the records that match the "Company
Name" field already entered on the form.

How do I do that?

 

[Arvin Meyer [MVP]]

You can do it with 2 combo or list boxes. Have a look at the sample:

http://www.accessmvp.com/Arvin/Combo.zip