setting find dialog box defaults

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get Access to open the find dialog box in a form using a
command button on an application that will be housed on a shared drive for
other users to access. But I want the Find dialog box to search the current
field only, and not all fields.

Private Sub searchunit_Click()
Unit.SetFocus
SendKeys "%ha%e"
DoCmd.RunCommand acCmdFind
End Sub

Any suggestions?
 
Create your own find form. You can present it exactly the same way and you
can control exactly the way you want. Little more work initially, but
better results in the end.

Greg
 
Back
Top