Rob-
OK. Assuming the search form is unbound (has no record source), add a combo
box to display the values you want. One of the columns should be the
Primary Key of the Record Source of the form you want to open, but it can be
a hidden column. Typically the Row Source will have two columns: The
Primary Key value and a display value. Make the Column width of the first
column 0 but make it the Bound Column.
Add a command button and put code similar to this in the Click event
(assuming the combo box name is MyCombo):
If Not IsNull(Me.MyCombo) Then
DoCmd.OpenForm "<name of other form here>", _
WhereCondition:="[<primary key name>] = " & Me.MyCombo
End If
John Viescas, author
"Building Microsoft Access Applications"
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
> -----Original Message-----
> From: [email protected]
> [mailto:[EMAIL PROTECTED] On Behalf Of rob linders
> Sent: Sunday, July 31, 2005 11:45 AM
> To: [email protected]
> Subject: RE: [ms_access] search option
>
>
> hi john
>
>
> thanks for your reply but he has to find
> a value in another form
>
>
>
> John Viescas <[EMAIL PROTECTED]> wrote:
> Rob-
>
> If you want the combo box to look up a value on the same
> form, use the combo
> box Wizard. Turn on the control wizards in the Toolbox and
> add a combo box
> to your form. Follow the steps to "Find a record on my form
> based on the
> value selected in my combo box."
>
> John Viescas, author
> "Building Microsoft Access Applications"
> "Microsoft Office Access 2003 Inside Out"
> "Running Microsoft Access 2000"
> "SQL Queries for Mere Mortals"
> http://www.viescas.com/
>
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[EMAIL PROTECTED] On Behalf Of linders_rob
> > Sent: Sunday, July 31, 2005 2:03 AM
> > To: [email protected]
> > Subject: [ms_access] search option
> >
> >
> > hi
> >
> > I'm pretty new to access and I have a problem.
> > I'm making a form to search a name I selected out of
> > a combo box.
> > When this name is selected i want to see the form or page
> > with all the details of this person.
> >
> >
> > Any idea how I have to do this?
> >
> >
> > regards,
> > Rob
> >
> >
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> > --------------------~-->
> > > href="http://us.ard.yahoo.com/SIG=12hlqdto6/M=362131.6882499.7
> > 825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122800562
> > /A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
> > ">Get Bzzzy! (real tools to help you find a job) Welcome to
> > the Sweet Life - brought to you by One Economy.
> > --------------------------------------------------------------
> > ------~->
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> ---------------------------------
> Start your day with Yahoo! - make it your home page
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> <font face=arial size=-1><a
> href="http://us.ard.yahoo.com/SIG=12ht188j3/M=362335.6886445.7
> 839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122835474
> /A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/to
> pics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http:
> //groups.yahoo.com/">In low income neighborhoods, 84% do not
> own computers. At Network for Good, help bridge the Digital
> Divide!</a>.</font>
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12h1ad2vf/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122836572/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</a>.</font>
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
