Programming the Search popup

  • Thread starter Thread starter Gary Schuldt
  • Start date Start date
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
 
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
 
Thanks, Geof,

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

Gary
 
Back
Top