My Assistant
![]()
Custom Search
|
![]() ![]() |
![]() |
![]() Post#1 | |
Posts: 36 Joined: 19-September 07 ![]() | 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. |
![]() Post#2 | |
UtterAccess VIP Posts: 4,457 Joined: 2-March 04 From: Suffolk, England ![]() | Create a new control. se the combo box wizard and the thrid option is to find. Use that, that should work for you. Jim |
![]() Post#3 | |
Posts: 36 Joined: 19-September 07 ![]() | 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. |
![]() Post#4 | |
Posts: 245 Joined: 20-September 05 From: Right here ![]() | Try this Me.Last_name.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 |
![]() Post#5 | |
Posts: 36 Joined: 19-September 07 ![]() | Worked like a charm! Thank you!!! |
![]()
Custom Search
|
![]() | Search Top Lo-Fi | 19th February 2019 - 04:00 PM |