find by form button

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aboyer - 09 Aug 2006 13:41 GMT

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?

Reply to this Message

kestrel_mw@yahoo.com - 09 Aug 2006 22:07 GMT

> 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

Reply to this Message

aboyer - 10 Aug 2006 13:08 GMT

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

> > 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,
[quoted text clipped - 18 lines]
>
> Kestrel

Reply to this Message