Can I create drop down multiple parameters in a query

S

SemperFi 1967

Is it possible to create a query parameter that acts as a drop down field
providing all the possible answers necessary (so that you can select the one
needed), to fulfill the paramenter that is being requested? The reason is
that when I do a normal parameter request, the users have been mispelling the
inputs (which are fairly long (20 to 35 characters long), and having to
retype or close out the report and lookup the exact spelling to do it all
over again. Any help would be greatly appreciated.

Ken
 
A

Allen Browne

No. This is one of the limitations the mean serious developers rarely use
the query parameter box. As well as the inability to provide
combo/listbox/checkbox controls, there is no way to range check the entry
(did the user really intend 1/1/206?), and the serial sequence of multiple
dialogs is annoying and inflexibile (once you okay that dialog, you can't go
back and fix a mistake) and inefficient (where some boxes are left blank.)

So, you probably want to build an unbound form where the user can enter
their criteria and click Ok to OpenReport, filter a form, generate a query
or whatever output you want. You can then provide drop-down lists, use a
multi-select listbox, validate the type and range of entries, and build a
much more efficient WhereCondition/Filter based on only the boxes where the
user entered something.

There is a simple introductory example in Method 2 of this article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

For a more complex example involving multiple fields of different types,
download this example:
http://allenbrowne.com/unlinked/Search2000.zip
 
S

SemperFi 1967

Allen;

Thanks for the quick response. I will give it a go on the suggestions you
gave.

Regards,
Ken
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top