J
jenn
i have a combo box that i need to fill.. the values of
this combo box and redependent of the value selected in
another combo box. This process should be in the
after_update of the first combo box, correct?.. how
exactly would i do this.. this is what i have (and i am
getting a type mismatch error on it, with
the ".recordsource" highlighted):
cmbState.RowSource = CurrentDb.OpenRecordset("SELECT
tblStateTaxDepts.StateAbrv FROM tblStateTaxDepts WHERE
tblStateTaxDepts.TaxType = '" & strTaxType & "';")
Any help would be greatly appreciated. thanks
this combo box and redependent of the value selected in
another combo box. This process should be in the
after_update of the first combo box, correct?.. how
exactly would i do this.. this is what i have (and i am
getting a type mismatch error on it, with
the ".recordsource" highlighted):
cmbState.RowSource = CurrentDb.OpenRecordset("SELECT
tblStateTaxDepts.StateAbrv FROM tblStateTaxDepts WHERE
tblStateTaxDepts.TaxType = '" & strTaxType & "';")
Any help would be greatly appreciated. thanks