I have a form that i've created a command button to search records, for some reason it is looking at a different field then I want it to. Here is what the VB says


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

How can I change it to look at last name? When it's selected it looks for Social. I know you can change the search just clicking in the field you want it to search but, but I would like it to default to name.

Create a new control.

Use the combo box wizard and the thrid option is to find.

Use that, that should work for you.

Jim

I think we may be talking different versions, I'm in 2002.

When I do the combo box wizard, there are no options about "find"

I just get a combo box with all the names in it.

Try this


Me.Last_name.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Worked like a charm! Thank you!!!