Filter code not working

  • Thread starter Thread starter DZ
  • Start date Start date
D

DZ

Hi

I am using this code to filter my form:
Dim strr As String
strr = Me.txtSearch

Me.FilterOn = True
Me.Filter = _
"[Library] like '*" & strr & "*'" _
& " or [Instrument] like '*" & strr & "*'" _
& " or [Location] like '*" & strr & "*'" _
& " or [Description] like '*" & strr & "*'" _
& " or [Comment] like '*" & strr & "*'"

The code works for all fields except the location field. All the fields are
text fields.
I tested the filtering of the Location field by entering various simple
words into the Location field for various records and when I type one of the
those words into Me.txtSearch and execute the code, those records are not
returned. All the other fields are working properly with this code.

Can any tell me why the Location field is not included in the filtered
results.


Thanks
 
On Wed, 22 Jul 2009 01:26:01 -0700, DZ <[email protected]>
wrote:

Btw, I typically first set the Filter property, then set FilterOn.

Perhaps because there is no Location field? Note that a filter
expression must use Field names, not Control names.

-Tom.
Microsoft Access MVP
 
Back
Top