Hi,
I created a form and then put a search button on the form. How can i set the search button Match Case to be Any part of field instead of it always stating at Whole Field?
Thanks
Here is the macro of the button:
Private Sub Command36_Click()
On Error GoTo Err_Command36_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_Command36_Click:
Exit Sub
Err_Command36_Click:
MsgBox Err.Description
Resume Exit_Command36_Click
End Sub
I created a form and then put a search button on the form. How can i set the search button Match Case to be Any part of field instead of it always stating at Whole Field?
Thanks
Here is the macro of the button:
Private Sub Command36_Click()
On Error GoTo Err_Command36_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_Command36_Click:
Exit Sub
Err_Command36_Click:
MsgBox Err.Description
Resume Exit_Command36_Click
End Sub