Docmd.RunCommand acCmdFind

[mbentley]

I want to call the default Find menu item (just as if the user had clicked the binoculars). That's as simple as pie. What I'd now like to do is change the default options for the user. (The 'Whole Field' default trips up users a lot). Anyone know how to do this?

 

[yellow]

Although not pretty you could do it like this:

SendKeys "%EF"
SendKeys "%HA"
SendKeys "%N"