Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I add a search to a form

Access Howto:

How can I add a search to a form

by  DougP  Posted    (Edited  )
This solution actually creates a new form from a table then adds a Find button. It can find data in any field you choose on the form.

Step 1. Click the tables TAB
2. single click your Table.
3. Click "Insert" Menu then "AutoForm". It will create a form in seconds.
4. In your form click "View" menu then "Design"
5. Click the "View" menu again and make sure the "ToolBox" menu is on. On the "Toolbar" make sure the Wizard button is depressed (it's the Wand with Fairy dust)
6. Drag a "Command Button" to your form.
7. In the "Categories" column Choose "Record Navigation"
the default.
8. In the "Actions" column pick "Find Record" (second one)
9. Click "Next" button at bottom
10. Choose either a picture or words for you button
11. Click "Next" button at bottom
12. Choose a name like cmd-Find for your button.
13. Click "Finish" button.

Now to test it Click "View" menu then "Form View"
Click in one of your textboxes like First name for example.
Click your New find button. A Dialog box will show.
The top heading should say something like "Find In Field 'First Name'". Always look at this heading to make sure you are Finding data in the correct field. If not you have to close the Find box and then single click in a different field then click the New Find button again.

Note: Look at all of the options on this dialog box and do several Searches using different options on the find box.

OK
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top