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?
Private Sub cmdFind_Click()
On Error GoTo Err_cmdFind_Click