Hi,
I crated a standard find button on a MS Access 2003 form. The code is below. I would like to default the "Look in" option to a field called "Name" and the "Match" option to "Any Part of field". is there away that I can do that?

Thanks



Private Sub cmdFind_Click()
On Error GoTo Err_cmdFind_Click


Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_cmdFind_Click:
Exit Sub

Err_cmdFind_Click:
MsgBox Err.Description
Resume Exit_cmdFind_Click

End Sub