Re: create a query that provides a drop down list to choose from
- From: Dabears70 <Dabears70@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 19 Dec 2007 11:57:00 -0800
Was this problem ever solved because I am having the same issue. Can somebody
please help me get a drop down menu in a parameter query. There are so many
items to chose from for the parameter that it is time saving to have a drop
down list.
Please help!
Thank you,
--
Nick
"Carolyn :)" wrote:
.
"Rick Brandt" wrote:
Carolyn :) wrote:
"john mcmichael" wrote:
Thank you both Allen and Gwen, but it doesnt seem to work. I haveI also tried doing what Allen & Gwen suggested, and also had no luck,
a form called Sample and a combo box labeled Combo 5. When I open
the form it work properly, listing the options and letting me
choose one. However, when Itype the criteria
[Forms]![Sample]![Combo5], the result is just a box that waits for
me type the criteria not providing me a list of options. ANy idea
where I'm falling off track?
can any shed some light on this. It would be a really handy tool to
be able to use a drop down box in a query/Report, when you ahve many
options to choose from.
The form has to be opened and the choice made *before* you open the query or
report that references it. Is that what you tried?
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Hi Rick,
Yes that is what I did. I typed it in the criteria same way as suggested, I
had the form open and it still didn't work. I am unsure what I did, or what
I am doing wrong?
- Prev by Date: Re: Can an update query be used to update/produce a query?
- Next by Date: Re: Can an update query be used to update/produce a query?
- Previous by thread: Crosstab - Null to Zero
- Next by thread: Re: Complex Query ?
- Index(es):
Relevant Pages
|
Loading
