cascade combo box

[ootkhopdi]

Sir
i have a table with three column Named
1-State
2-City
3-Customer

on a form i m placing 3 combo box for each column

how can i filter combo 2 from table after select value from combo 1

 

[kes]

in the row source of the City combo box put the query:
select City from 'yourtblname'
where State= [Forms]![yourformname]![Citycombobox]

in the afterupfadte event of the state combobox put:
me.Citycombobox.requery
me.Citycombobox= ""

do the same for Customer...