How are you entering the single value?
There are several ways of doing this. The critical information is that the query Criteria is
Like [Please enter the first letters of the last name] & "*"
For example. This criteria will run an input box with the title in brackets, then take the letter(s) entered and show you all the records (LastName) that START with the letter(s) entered.
If you want to search for a string anywhere in the text, use
Like "*" & [Please enter the first letters of the last name] & "*"
There are other ways to get the search criteria, like a combo box or text box.
In one version of this I have the underlying query display some fields of the search results in a continous form, and there is a button on the form to open the complete record, or a transaction form from the continous form.
What do you want to do?
HTH
mmcdonal
|