Filter a combo box based on another combobox?

Question

I am creating an access 2010 database with information about aircraft type information.

I have 4 Combo Boxes;

Aircraft Make
Aircraft Model
Aircraft Variant
Aircraft Feature

I would like to filter the model combo box based on the selection in Manufacturer box, then variant combo box based on selection in the model combo box etc etc....

The code below is what I have currently entered for the 'Aircraft Model' Filtered list...

SELECT tbl_AircraftModel.[Aircraft Model], tbl_AircraftModel.lku_ShortCode

FROM tbl_AircraftModel

WHERE tbl_AircraftModel.lku_ShortCode = tbl_Aircraft.[Make]'

However this just asks me to Enter a parameter value?

Please can somebody point me in the right direction?

tbl_Aircraft is not included in the FROM clause, so Access is puzzled by tbl_Aircraft.[Make] in the WHERE clause. Shouldn't that reference the value selected in one of your other combo boxes (perhaps Aircraft Manufacturer)? — HansUp
'tbl_Aircraft.[Make]' is the combobox from which the aircraft model combobox should filter its options? — Luke Smith
yeh, that field uses a combo box with data from tbl_AircraftMake — Luke Smith
With the form in design view, right-click that combo box and select Properties from the dropdown list. Then on the property sheet, choose the "Other" tab and tell us what text appears immediately to the right of "Name". — HansUp

Narveson Narveson · Accepted Answer · 2013-05-01T17:41:47

What you wish to do is a routine task in MS Access forms.

Create a form based on your table. On the form, place some unbound combo boxes. When you want the user selection in Combo Box A to alter the choices displayed in Combo Box B, make the AfterUpdate event of Box A call the Requery method on Box B.

Filter a combo box based on another combobox?

1 Answers