hey guys,
i have a combo box on a subform that i want to use a query as the rowsource. the problem is when i try to add another control(combo box) as criteria to the query. I tried this which I believe should work but its not
[form]![tblmaterialbomcomponent]![Plant]
tblMaterialbomcomponent is the name of the subform.
then i would like to refresh this rowsource everytime the combo box is accessed.
all help would be appreciated, thanks.
-Mike
i have a combo box on a subform that i want to use a query as the rowsource. the problem is when i try to add another control(combo box) as criteria to the query. I tried this which I believe should work but its not
[form]![tblmaterialbomcomponent]![Plant]
tblMaterialbomcomponent is the name of the subform.
then i would like to refresh this rowsource everytime the combo box is accessed.
all help would be appreciated, thanks.
-Mike