filter options in a combo box

[Lori]

I have a "sales order" form with a combo box to select the
customer and the contact to enter into the form.
(contacts and customers tables are linked). For example.
Bob Smith, Ted Jones, and Maria Green who work at ABC
Company. What I want to do is filter the selections in
the combo box for the contact and only show contacts that
that are linked to the company that the user selected
within this form. User selects the company first. Any
suggestions?

Thanks.

 

[Douglas J. Steele]

One approach is outlined in http://www.mvps.org/access/forms/frm0028.htm at
"The Access Web"