how do i apply a filter to a subform

[smoke]

hi i have this subform that's shown as a table inside my main form, i was wondering how i would have a combo box on the main form that applied a filter according to the user's selection and applied it to the subform. thanks

as of right now im using

private sub frmwhsegroup_afterupdate()
me.filter = "tblinvpn =" &me.frmwhsegroup
me.filteron = true
end sub

i know its somethign to do with pointing the tblinvpn object to the subform, but i've tried several time with differnt syntax, and i still can't get it to work,could someone help me out? appreciate the help, thanks.

 

[ssoltic]

follow the link:

http://www.mvps.org/access/forms/frm0023.htm