Selective Content Combo Boxes

[karatelung]

I have two combo boxes, A and B. I want the list of selections in combo box B to be dependent on the selection made in combo box A.

For example, if I select "Paper" in combo box A, i want the selections in combo box B to be limited to "glossy" and "legal". If I select "Rock" in combo box A, i want the selections in combo box B to be limited to "granite" and "limestone".

Can someone please help me?

 

[llkhoutx]

The recordsource of combobox 2 is a query that uses the present contents of combo box 1 as criteria. Be sure to requery combo box 2 after each selection (afterupdate) of combo box 1. This can be done with ids or with actual data.