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....
"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....