Filter Combo Box on a table based on previous fields values

[ChrisA1967]

This should be so simple but i can't for the life of me figure out how to do it.



3 tables tblOrders, tblCountries, tblCourierServices

So tblCountries has a countries field:- France, Germany, United Kingdom etc

tblCourierServices has fields Country, CourierService:- France - La Poste, France - DHL Worldwide Express, Germany - Hermes, Germany Deutsche Post, Germany - DHL Worldwide Express, United Kingdom - Royal Mail 24, United Kingdom - Royal Mail 48

tblOrders has a country field where it gets a list of countries from tblCountries - so combo box linked to the countries field in tblCountries and the user selects the country that is no problem

The next field in tblOrders is delivery_method - now I need it to filter tblCourierServices according to what was entered in the country field. So for example if United Kingdom is selected in the country field it only shows Royal Mail 24 and Royal Mail 48 in the combo box.

Should be so simple. Any assistance would be gratefully received.

[ranman256]

combo2 source uses combo1 as criteria in the query,
but you must refresh combo2 when combo1 is chosen....

combo2 bound data is:
cboCourier.rowsource = qsCourier1Country

qsCourier1Country sql
= select Couriers from tCourier where [Country]=forms!myForm!cboCountry

so the only event you need is:

'----------------
sub cboCountry_Afterupdate()
'----------------
cboCourier.requery
end sub