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

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" <John@nospam.infovis.co.uk> wrote in message
news:40869f94$0$20397$cc9e4d1f@news.dial.pipex.com ...[color=blue]
>
> Is there a way to bring up find dialog through code while on an access[/color]
form?[color=blue]
> Basically I want the find dialog to come up immediately after the form is
> loaded.[/color]

On Wed, 21 Apr 2004 17:21:33 +0100, "John" <John@nospam.infovis.co.uk>
wrote:
[color=blue]
>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.[/color]

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