Hi everyone,
SELECT PplInfo.*
FROM PplInfo
WHERE (((PplInfo.EmpName) Like "*" & [Forms]![srchform]![NameSrch] & "*") AND (([Female]=[Forms]![srchform]![Femchk] Or IsNull([Forms]![srchform]![Femchk]))<>False) AND ((PplInfo.Location) Like "*" & [Forms]![srchform]![LocSrch] & "*") AND...
Those didn't really show me anything that helped. My search query (filtered by text boxes and triple state checkboxes on my search form) still doesn't show me any of the results that I entered after I made the query. Even when I open the whole database up again!
Hiya,
I'm reasonably new to access and I've managed to muddle through coding things etc to make a (mostly!) functioning database.
My problem is this: I have a query that is run from a search form. This all works swimmingly and used to return all results when nothing was entered in the...