Open Find Dialog

This example opens the Find dialog box. The keystrokes sent by the SendKeys action are: ALT+H to select the Match box, "a" to select Any Part Of Field, and ALT+N to select the Find What box. For more information on this topic see ACC: How to Set Defaults for the Find Dialog Box on the Microsoft Knowledge Base.

To try this example out, create a button on a form and call it cmdFind. Put the following code behind the On Click event.

'***************** Code Start *******************
'This code was adapted by Terry Wickenden.
'from a macro example ion the Microsoft Knowledge Base

Private Sub cmdFind_Click()
   Screen.PreviousControl.SetFocus
   SendKeys "%ha%n", False
   DoCmd.RunCommand acCmdFind
End Sub

'****************** Code End ********************

Return to Example List