Apply filter: how to?

[Vu_Ho]

I Have 2 combo box on a form: Product_Type (6 values) and Product_Name (30 values and each belongs to a type), I want to narrow down the Product_Name to related Product_type whenever I select a type in the first field. Is there anyway to do this? Thanks

 

[Alansidman]

Cascading Combo Boxes is the term you need for this exercise. Look at this link. He provides two methods to achieve this.

http://www.fontstuff.com/access/acctut10.htm

 

[Vu_Ho]

Thanks alansidman, can this method apply to a query? or it must be a table? 'cause my two control are based on a query.