I am working on doing a simple search. In my test(testing whether or not I know what I am doing) access form, I set the row source as
I have a requery button that causes the target unbound list box to refresh according to what is in the search box but it displays nothing when nothing is in the search box.
How would I cause it to display everything when nothing is in the search box?
SELECT Results.ID, Results.fname, Results.lname, Results.address, Results.city, Results.state, Results.zip, Results.phone
FROM Results
WHERE (((Results.fname)=[Forms]![Search]![Text2]));
FROM Results
WHERE (((Results.fname)=[Forms]![Search]![Text2]));
How would I cause it to display everything when nothing is in the search box?
Comment