Combobox criteria from another combobox

[MTSPEER]

Hello,

I have a combo box(cmboQueue) with values in it based on a query from the row source. And I want to put in another combo box where I will have to create another query based on what the value is selected in cmboQueue. Is that possible? Do I do that in the row source of the new combo box?

[ranman256]

combo 2 source uses combo1 as criteria in the query
but you must refresh combo2 when combo1 is chosen....

cboStates has all state names. When user picks a state, the cboCity must be refreshed
cboCity.rowsource = qsCities1State
sql= select City from tCities where [state]=forms!myForm!cboState

'----------------
sub cboState_Afterupdate()
'----------------
cboCity.requery
end sub

[MTSPEER]

What if I wanted to pull it from multiple fields? For example just for some reason I had cities in multiple fields and I have one state field. is that possible?