The Find feature defaults to the selected field, which means you, could end up searching just the active field, in place of the whole table. When using the Find option in Access, you can change the default search options to something that probable more to your own search options:

1. Select Tools Options from the menu bar. Click on the Edit and then find tab.

2. Choose the option button you want from the Default Find and change Behavior panel.

3. Fast Search is the default, and causes Access to seek the current field for an exact equivalent to your field.

4. General Search searches all fields and checks any part of the field.

5. When you've decided on the proper search field, click OK.