I used the Command Button Wizard to create a button that calls the Find Record window. Is there anyway to modify the vb code so that the default for the Match options is set to "Any Part of Field"?
Also if it is possible, I would like for the Replace tab to be removed or disables.
Thanks!
Here is the line of code the wizard generated:
Private Sub RUN_A_SEARCH_BUTTON_Click()
On Error GoTo Err_RUN_A_SEARCH_BUTTON_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_RUN_A_SEARCH_BUTTON_Click:
Exit Sub
Also if it is possible, I would like for the Replace tab to be removed or disables.
Thanks!
Here is the line of code the wizard generated:
Private Sub RUN_A_SEARCH_BUTTON_Click()
On Error GoTo Err_RUN_A_SEARCH_BUTTON_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_RUN_A_SEARCH_BUTTON_Click:
Exit Sub