Programming the Search popup

G

Gary Schuldt

I want a command button to bring up the same built-in Search popup Access
gives you when you hit
Ctrl-F, but I want to be able to set the search parameters to

Look in: <the whole current form, not just the current field>

Match: <any part of field>.

How do I do this either in a macro or in VBA?

Right now I'm doing this all manually:

Ctrl-F
<type in the search contents>
Click the Look in dropdown to choose the form name
Click the Match dropdown to choose "any part of field"

It seems as though there'd be an easier way.

Gary
 
G

Geof Wyght

Gary,
There is a way with VBA. Have a look at Help for the
FindFirst method. From the user's viewpoint it will be
easier. From the developer's viewpoint, it will be more
work. Good luck.
Geof Wyght
 
G

Gary Schuldt

Thanks, Geof,

I'll take a look. After all, the goal is a better user interface.

Gary
 
Top