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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.