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

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