Filter based on part of value

[bikeordie1]

Hi, New to the forms here



Looking for help on a special filter. I'd like to filter a field on a report based on if a string is anywhere within the field. So prompt the user for entry (they enter "red") and it filters [Description] for anything that contains the word red somewhere in that field. I'm familiar with using a filter "[description] = " & SearchInput!Criteria. But that only grabs fields that just say "red" only.

Thanks for the help!

[pbaldy]

You use Like and wildcards, like:

"[description] Like '*" & SearchInput!Criteria & "*'"

[bikeordie1]

you are my savior. worked great thanks

[pbaldy]

Happy to help!