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

  • Thread starter Thread starter Jen
  • Start date Start date
J

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
 
Me.Filter = "[ItemNo]=" & Chr(39) & strItemFilter
& Chr(39)
Me.FilterOn = True
Click to expand...

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
 
Back
Top