In the graphical query layout view, go to the column you want to filter info on and use [] to generate the prompt. For example, if I had a product table and wanted it to prompt for something, I would make a query for tblProduct, and under prodCompany I would put [Please enter company name] in the criteria section, using the brackets. That will make a prompt window come up with "Please enter company name" and a blank to put in the info. In SQL view it would look like this:
SELECT *
FROM tblProduct
WHERE (((tblProduct.prodCompany)=[Please enter company name]));
If I wanted it to match partial names, I would use:
SELECT *
FROM tblProduct
WHERE (((tblProduct.prodCompany) LIKE "*" & [Please enter company name] & "*"));
The * wildcard will then let partials like "so", "on", and "ny" match "Sony" in the prodCompany column.
Lastly, if you want to add support for wildcards AND the ability to click "OK" with a blank field and have it return ALL records (no filter) then use this:
SELECT *
FROM tblProduct
WHERE ((([tblProduct].[prodCompany]) Like "*" & [Please enter company name] & "*") And (([Please enter company name]) Is Not Null)) Or ((([Please enter company name]) Is Null));
This will let it handle blank entries and combines that with support for wildcards.
HTH
ComponentOne Studios for .Net and ASP.Net - Install Issues
Index