filter subform created from query

[spiz via AccessMonster.com]

Hi,
How can i filter a subform created from a query with an unbound combo box?
Thanks

 

[Klatuu]

Put a WHERE clause in your subform's record source query to filter on the
value of the Combo Box:

WHERE [SomeField] = Forms!MyFormName!MyComboName

Then in the After Updat event of the Combo:

Me.MySubformControl.Form.Requery

 

[spiz via AccessMonster.com]

Thank you, however, i keep getting bugs from the code
i could just be doing this wrong

Put a WHERE clause in your subform's record source query to filter on the
value of the Combo Box:

WHERE [SomeField] = Forms!MyFormName!MyComboName

Then in the After Updat event of the Combo:

Me.MySubformControl.Form.Requery

Hi,
How can i filter a subform created from a query with an unbound combo box?
Thanks