Hi all. Here is the situation.
I have a form. I put a button on it following these steps.
Drag the button from the toolbox onto the form.
Choose Record Navigation and Find Record from the list boxes.
Choose the Icon
and Name it.
Now, the search box pops up after clicking the button.
The Look in: drop down box contains 2 items
ID (the primary key)
and EntryForm (the form)
ID is listed as default
The Match: Dropdown box contains.
Any Part of Field
Whole Field
and Start of Field
Whole Field is the default.
I want to change the defaults to Entry form and Any Part of Field.
Any tips for me?? Here is the code if helpful.
Private Sub Command32_Click()
On Error GoTo Err_Command32_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_Command32_Click:
Exit Sub
Err_Command32_Click:
MsgBox Err.Description
Resume Exit_Command32_Click
End Sub
Thanks everyone.
PB
I have a form. I put a button on it following these steps.
Drag the button from the toolbox onto the form.
Choose Record Navigation and Find Record from the list boxes.
Choose the Icon
and Name it.
Now, the search box pops up after clicking the button.
The Look in: drop down box contains 2 items
ID (the primary key)
and EntryForm (the form)
ID is listed as default
The Match: Dropdown box contains.
Any Part of Field
Whole Field
and Start of Field
Whole Field is the default.
I want to change the defaults to Entry form and Any Part of Field.
Any tips for me?? Here is the code if helpful.
Private Sub Command32_Click()
On Error GoTo Err_Command32_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_Command32_Click:
Exit Sub
Err_Command32_Click:
MsgBox Err.Description
Resume Exit_Command32_Click
End Sub
Thanks everyone.
PB