query as rowsource on subform

[MikeDNova]

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

 

[MikeDNova]

got it, had to refer to it as parent
[parent].[form]![tblmaterialbomcomponent]![Plant]

now just have to refresh... should be easy...