Filtering records in a sub-form of a sub-form

[Jen]

Just a thought, but try replacing the Chr(34) - double
quote with Chr(39) - single quote.

Me.Filter = "[ItemNo]=" & Chr(39) & strItemFilter
& Chr(39)
Me.FilterOn = True

I'm crossing my fingers!
Jen

 

[Tim Ferguson]

Me.Filter = "[ItemNo]=" & Chr(39) & strItemFilter
& Chr(39)
Me.FilterOn = True

Isn't it likely that a field called ItemNo is numeric rather than textual?

I'd suggest

Me.Filter = "ItemNo = " & strItemFilter

Of course, it's a bit confusing having the ItemFilter as a string variable:
where is this value coming from?

HTH


Tim F