Find Record "Look In" Selection

B

BobbyOH

I'd like the Find Record Dialog box "Look In" field to default to my
"LastName" field on my form while Matching any part of the field. It doesn't
always default to the LastName field but to the entire form.

I used the toolbox to create a command button which brings up the Find
Record dialog box.
I set the Tools-Options-Edit/Find setting to General Search and modified the
On Click event to go to the "LastName" field when the button is clicked:

Private Sub cmdFindRecord_Click()
On Error GoTo Err_cmdFindRecord_Click

DoCmd.GoToControl "LastName"
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_cmdFindRecord_Click:
Exit Sub

Err_cmdFindRecord_Click:
MsgBox Err.Description
Resume Exit_cmdFindRecord_Click

End Sub

Is it possible to do this? Thanks....
 
Top