Combo box options dependant on value of another combo box

[charlie442]

Hi gurus

I have a form in which I have two combo boxes. The first selects tax type and the second selects query type. Different tax types have their own unique list of query types as per the Tbl_Query_Types.

I want the 2nd combo box to only show selections available relating to the tax type chosen in the 1st. Hope that all makes sense. I figure it has something to do with the where condition in the row source statement but I am struggling to get it right.

The statement I currently have is :
Select Tbl_Query_Types.Tax_Type, Tbl_Query_Types.Qry_Type From Tbl_Query_Types Where Tbl_Query_Types.Tax_Type = Forms.Data_Capture_Form.cbo_Type

Any help on this appreciated as always.

 

[John Big Booty]

I think what you are looking for is a Cascading Combo box set.

 

[charlie442]

Thanks mate. That is incredibly useful!