Modifying the default find tool

[broncojim]

I am looking for a suggestion to modify the default find tool for my form.
In order to search a specific field, you must give that field the focus on
the form to run the search. I would like to add code to the default tool so
that you can pick which field you want to search using the LookIn combo box.
I would paste a picture of what I am talking about but it is restricted. The
default find tool allows a search of either the field that has the focus or
the entire form. The names of the fields I want to search are FACILITYID and
SERIALNUMBER.

 

[Tom van Stiphout]

On Fri, 3 Oct 2008 14:49:01 -0700, broncojim

Write your own form.
Then you can do even better: I bet a FacilityID and a SerialNumber are
so different you don't have to ask your user to identify the field:
just figure it out from the value provided.

-Tom.
Microsoft Access MVP