Restrict Second combo to First combo

[Trevor Howard]

I am making a “service” form, which holds it data in a “service” table, I need to select a company via a combo from “company” table, this all works fine, but then have a second combo select only one contact from a list of contacts for that same company (Contact linked to Company one to many).

Any ideas greatly appreciated. Thanks

Trevor

 

[llkhoutx]

A column in the rowsource for the second combo box should be filtered by the bound column of the first combo box.

 

[Trevor Howard]

WOW, that was quick!!

Thank you for that, off to try it.

Regards