UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Easy Question, modify a search button on form    
 
   
mmishkin
post Apr 2 2008, 02:14 PM
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.
Go to the top of the page
 
AQM_UK
post Apr 2 2008, 02:19 PM
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
Go to the top of the page
 
mmishkin
post Apr 2 2008, 02:30 PM
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.
Go to the top of the page
 
manrav1
post Apr 2 2008, 03:28 PM
Post#4



Posts: 245
Joined: 20-September 05
From: Right here


Try this
Me.Last_name.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Go to the top of the page
 
mmishkin
post Apr 3 2008, 09:49 AM
Post#5



Posts: 36
Joined: 19-September 07



Worked like a charm! Thank you!!!
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd May 2018 - 08:57 AM