Roger
In the criterion row under the field you are searching, enter something like
(actual syntax may vary):
Like *[Enter something you want to find]*
This finds whatever is entered in ANY location.
If you use:
Like [Enter the starting few characters]*
Access will only search for values STARTING with what's entered.
--
Good luck
Jeff Boyce
Access MVP
|