search command on form

K

KR

I want to create a command button on my form so that I can search any field
on the form and the records that match it will pull.

So basically I want to be able to type the info. I am looking for in a box,
click on the search button and have it pull up the info. that matches the
info.
 
G

Golfinray

Put a combo box on your form. Allow the wizard to do that for you and set up
whatever you want to search for, like an ID, a person name, whatever. Then
right click on the combo and go to properties. Go to events. Go the after
update event. click the little button out to the right and start the code
builder. Type:
Me.Filter = "[ID or whatever] = """ & Me.Combo# & """"
Me.filteron = True
The combo # will be listed, like combo10 or combo23.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Help me create a serach to search my form PLEASE NO COMBO BOX 4
Go to specific record in a form PLEASE HELP ME :) 1
Form to search for Customer 1
Search through Forms 2
Searching a Table on a Form Using Drop Down Text Boxes 3
Search Form Using Three Criteria 7
Access Automatically Send a notification email once a record is added 0

Top