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!frmUrgentTriage1.tboCaseID
Me.FilterOn = True

[JohnHo]

thanks - where is that secret kept?

[OldBirdman]

Access Help -> Filter Property