Find Dialog

[John]

Hi

Is there a way to bring up find dialog through code while on an access form?
Basically I want the find dialog to come up immediately after the form is
loaded.

Thanks

Regards

[Allen Browne]

Try:
RunCommand acCmdFind

If you want to search a particular field, be sure to SetFocus first.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:40***********************@news.dial.pipex.com ...

Is there a way to bring up find dialog through code while on an access form? Basically I want the find dialog to come up immediately after the form is
loaded.

[Mike Preston]

On Wed, 21 Apr 2004 17:21:33 +0100, "John" <Jo**@nospam.infovis.co.uk>
wrote:

Hi

Is there a way to bring up find dialog through code while on an access form?
Basically I want the find dialog to come up immediately after the form is
loaded.

Yes, you can put VBA into the form's OnLoad event. If you explain in
a bit more detail what "the find dialog" is, then somebody can suggest
more specifics.

mike