|
 |
access thread: Drop down lists in parameter queries
Message #1 by "Dr Craig A Thompson" <Craig.Thompson@d...> on Wed, 20 Mar 2002 13:19:24
|
|
Is it possible to create a drop down list to select from in a microsoft
access 97 query. I would like to be able to offer the user the ability to
select one of fourteen fixed parameters rather than have to type in the
parameter value.
Craig
Message #2 by Omar Chaudry <OChaudry@b...> on Wed, 20 Mar 2002 13:26:03 -0000
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1D012.C88FA390
Content-Type: text/plain
The way to do this is to create a from with a combo/list box control
containing your 14 parameters, let the user pick the required one and pass
this to the query (you can put something like
=form!formname!controlname!value in the criteria box of the relevant field
in the query).
HTH
Omar
-----Original Message-----
From: Dr Craig A Thompson
[mailto:Craig.Thompson@d...]
Sent: 20 March 2002 13:19
To: Access
Subject: [access] Drop down lists in parameter queries
Is it possible to create a drop down list to select from in a microsoft
access 97 query. I would like to be able to offer the user the ability to
select one of fourteen fixed parameters rather than have to type in the
parameter value.
Craig
DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.
Message #3 by "Dr Craig A Thompson" <Craig.Thompson@d...> on Wed, 20 Mar 2002 16:32:33
|
|
> This message is in MIME format. Since your mail reader does not
understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1D012.C88FA390
Content-Type: text/plain
The way to do this is to create a from with a combo/list box control
containing your 14 parameters, let the user pick the required one and pass
this to the query (you can put something like
=form!formname!controlname!value in the criteria box of the relevant field
in the query).
HTH
Omar
-----Original Message-----
From: Dr Craig A Thompson
[mailto:Craig.Thompson@d...]
Sent: 20 March 2002 13:19
To: Access
Subject: [access] Drop down lists in parameter queries
Is it possible to create a drop down list to select from in a microsoft
access 97 query. I would like to be able to offer the user the ability to
select one of fourteen fixed parameters rather than have to type in the
parameter value.
Craig
DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to
this
message by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.
|
|
|
View Cart
