user input for a search

C

Chuck216

I have an Access application that I have all the menus shut off the only
navagation is thru commands on the forms. I would like to add a search
function connected to a command button that would go to a specific field and
then open a input box for the user to enter what they are looking for in that
field. Thanks
 
K

KARL DEWEY

Try this --
In the header of the form put unbound textbox, combox, or listbox to enter
or select the criteria. Add a command button to requery the query that is
the record source for the form.
In the query add criteria from each of the textbox, combox, or listbox from
the form header like --
Like "*" & [Forms]![YourFormName]![YourTextBox] & "*"

If you have entered 'be' in the textbox you will get Abe, Abel, Betty, Maybe.

If you do not use the leading or trailing wildcards you will limit what you
pull.
 
Top