Here is the SQL for ComboBox1:

SQL = "SELECT * FROM Table1 WHERE " _
& "Table1.prType =" & Chr(34) & "hot" _
& Chr(34) & " AND Table1.prUse =" _
& Chr(34) & "base" & Chr(34) & ";"

Change the table name to suit and "base" for ComboBox2 and ComboBox3.

Hth,
Merjet