Full Version: Easy Question, modify a search button on form
UtterAccess Forums > Microsoft® Access > Access Forms
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
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.
se the combo box wizard and the thrid option is to find.
Use that, that should work for you.
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
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Worked like a charm! Thank you!!!
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.