Filter

[Guest]

I have set up a filter as follows:

strWhere = strWhere & "([FirstName] = '" & _
Me.FirstName & "')

DoCmd.OpenForm "AgencyInfo", , , strWhere

This allows me, for example, if the name entered in FirstName is Kimberly to
filter for all Kimberlys. Is there a way to do a fiter not for an exact value
but for an includes value. Therefore if the name entered in FirstName was
Kim, Kimberly would still show up in the filtered values? Thanks!

 

[Guest]

Try this (untested):

strWhere = strWhere & "([FirstName] LIKE " & _
Chr(34) & Me.FirstName & "*" & Chr(34) & ")"


Note: I like using Chr(34) in place of the single quote, because the use of
a single quote will blow-up for any data that includes this character, a name
like O'Donnel, for example.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________