creating and using a filter

[JohnHo]

I am trying to use the filter method with a form

Using the Access/VBA documentation I have created a filter which looks like this

me.filter = "lngCaseID = 18905"
me.filter on = true

this works fine.

I have tried using the same method including a varible based on a control

it looks like this

Me.Filter =  """lngCaseID = " & Forms.frmUrgentTriage1.tboCaseID  _ & """" 
me.filter on = true

or

thisFilter = """lngCaseID = " & Forms.frmUrgentTriage1.tboCaseID  & """" 

me.filter = thisFilter
me.filter on = true

and neither works despite the fact that when I debug.print the string is the same string as if I hard coded it.

any suggestions.

thanks greatly!!

[OldBirdman]

thisFilter = "lngCaseID = " & Forms!frmUrgent Triage1.tboCase ID
Me.FilterOn = True

[JohnHo]

creating and using a filter

thanks - where is that secret kept?

[OldBirdman]

Access Help -> Filter Property