Adding wildcards to a query from a form

[Danialle]

I am trying to allow users to search a memo field using a keyword, so I need to be able to add the LIKE "*comments*" to the query criteria, but comments is from a form. This is the code I came up with, but it does not work

criteria: Like "*[Forms]![FormQuery].[comments]*"

where FormQuery is the Form and comments is the memo field.

Can you help? Thanks

 

[jebry]

Hi!

Try this:

Like "*" & [Forms]![FormQuery].[comments] & "*"

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Danialle]

This was just what I needed. Thanks!