filter options in a combo box

  • Thread starter Thread starter Lori
  • Start date Start date
L

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.
 
Back
Top