Access 2007 form view search box

[Jim]

I have Office 2007 (moving up from Office 97) and am developing a database
using Access 2007. In form view, at the bottom with the record selector is a
search/find dialog box. It searches every field in the database however I
want to limit it to searching only selected fields. Can I get at the code
for this search function or do I have to turn off the navigation buttons and
build my own record selector and search funtion?

Thank you.

 

[Allen Browne]

Jim, I don't think you can configure that search box in the horizontal
scroll bar of A2007.

Perhaps you could add something like this:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
This utility consists of a combo (for choosing what field to look in) and a
text box (for the value to find.) You copy the code, put these 2 controls on
your form, and set one property.

You don't need to modify the code: it just works with any form.

 

[Jim]

Thanks, that's what I expected, but figured it didn't hurt to ask. At first
glance, I may be able to use your code, it provides more than I planned but I
like the idea of allowing the user to select which field to search.