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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Easy Question, modify a search button on form    
 
   
mmishkin
post Apr 2 2008, 02:14 PM
Post #1

UtterAccess Member
Posts: 36
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,447
From: Suffolk, England
Create a new control.

Use 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

UtterAccess Member
Posts: 36
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

UtterAccess Addict
Posts: 245
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

UtterAccess Member
Posts: 36
Worked like a charm! Thank you!!!
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 26th May 2013 - 04:36 AM