search button to search on particular field

[tizwaz]

Is it possible to create a search button that will just search on one field. (I know if you click in the required field and then click a normal search button it will do that but they don't want to do that)
This is the code created by the wizard
Private Sub Search_Click()
On Error GoTo Err_Search_Click

Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_Search_Click:
Exit Sub

Err_Search_Click:
MsgBox Err.Description
Resume Exit_Search_Click

End Sub

I thought maybe I could set the focus on the form so that when you click the button it automatically searches on that field but am not a coder and don't know how to go about it.
Can anyone help?

 

[flyboy66102]

You are on the right track, what I do is put a small command button next to the field I want to search by.

myTextBox.SetFocus

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_Search_Click:
Exit Sub

Err_Search_Click:
MsgBox Err.Description
Resume Exit_Search_Click

This should work nicely for you.