Change select list in combo2 after update of combo1

[Garry]

Hi
MS Access 2010

I have 2 tables 'Carrier' and 'Driver' with relationship 'CarrierID' 1 to many 'Carrier'.

In the form 'Consignment'
I have combo1 select a 'CarrierID' After_Update it populates several field with address and phone number.

What I need is for combo2 to list only 'Driver' in the dropdown from the 'Driver' table related to the company selected in combo1

[Stewart Ross]

You may find our Insight article on cascading combo boxes assists you with your requirements.

-Stewart