Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Access Other topics FAQ

Access Howto:

How can I add a search to a form by DougP
Posted: 2 Jun 00

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.


Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close