I have a form with several fields that I want to search on. I copied the form, and made all of the fields unbound, and created a query that includes all of the fields. They have SQL like below, so I can enter criteria to any number of the fields and find the records. I would imagine that if nothing was in a field, the SQL would search for ** which I thought would return all records, but it doesnt. The SQL below only finds records with data in that field.
What am I doing wrong?
SELECT tblMain.BkgCtrName
FROM tblMain
WHERE (((tblMain.BkgCtrName) Like “*” & [Forms]![frmSearchForm]![txtBkgCtrName] & “*”));
Thanks,
Randy