Filtering a subform using a combo box on the main form

[scottian]

i know this forum is littered with this request but for some reason i cant get any of the the answers to work for me.
The one bit of code that keeps popping up is this one
Me.YourSubForm.Form.Filter = "[FieldName] =" & Me.YourComboBox
Me.YourSubForm.Form.FilterOn = True
but i keep getting the error
"Run-time error '2465':
access cant find the field 'subfrmNewIssues' referred to in your expression.
You may have misspelled the field name, or the field may have been renamed or deleted"

But its not a field its a form.
This is my version of the code above which i placed in the after update event of the main forms combo box

Me.[subfrmNewIssues].Form.Filter "[SystemApplication] =" & Me.Combo55
Me.[subfrmNewIssues].Form.FilterOn = True

i hope someone can help me.

"My God! It's full of stars...

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

You may also play with the expression builder (loaded forms) to discover the name of the control hosting the subform

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Dor100]

What about changing the recordsource based on the combo's value and then requerying the subform?