find by form button

[Guest]

I would like to make a button on a form just like the "find by form" button
on the toolbar at the top of the screen. Using the command button wizard,
you can choose the picture but it doesn't give you an option to create just a
simple "find by form" button. Is there a way to do this?

 

[kestrel_mw]

I would like to make a button on a form just like the "find by form" button
on the toolbar at the top of the screen. Using the command button wizard,
you can choose the picture but it doesn't give you an option to create just a
simple "find by form" button. Is there a way to do this?

If by "Find by Form" you mean "Filter by form", then right click your
command button, select "Build Event", the the Code builder, and insert
the following command into the button's event code:

Docmd.RunCommand AcCmdFilterByForm

If you're trying to open the Find dialog box, you could insert this
command:

SendKeys "^f"

But in that case your users could just hit Ctrl+f and accomplish the
same thing.

HTH

Kestrel

 

[Guest]

Thank you very much. I apologize for the incorrect terminology.
I guess that's why I chose the new users discussion.