setting find dialog box defaults

B

brerrabbit315

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?
 
G

Greg

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top