>Can you use a wildcard in the where clause of a select statement?
>
>
>if thisform.cToShow = "All"
> lcCatToShow = "" &&>>> This is where I want a wildcard

You can use wildcarding in at least two ways.
Standard DOS-style wildcarding (? matches any single character, * any number of characters) using the LIKE() function in your WHERE clause rather than equivalence; IOW, rather than CatLink.Catagory == lcCatToShow , you'd say LIKE(lcCatToShow,CatLink.Catergory,) .

Alternatively, you can use the SQL LIKE Clause (% == *, _ == ?), so that instead of CatLink.Catagory == lcCatToShow you'd say CatLink.Category LIKE lcCatToShow.