I have a Search form that uses a combo drop down box to find LIKE data in an associated query.
Example: Like "*" & [Forms]![Drop Down Search Form]![Gender] & "*"
This works fine for all data that is completely different, but it finds everything when I look up either Male or Female. This of course is because they both contain the word Male.
If I try using:
=[Forms]![Form1]![Gender]
Then it forces my combo drop down to be used to pick one or the other (male or Female) . This is an issue because sometimes I need to leave the field blank to find both female and male.
To recap:
=[Forms]![Form1]![Gender] forces me to pick on or the other ( Male or Female)
Like "*" & [Forms]![Drop Down Search Form]![Gender] & "*" will find both Male and female.
Any suggestions for a criteria where I can either pick one or the other to get the specific results AND also have the option to leave the field blank to find both?
Thanks -W