Parameter Query Using DropDownList instead of typing info ?

[traversd]

Hi,

Doe anyone know how it would be possible to run a parameter query, but have the parameter selected from a drop down list (ComboBox) instead of typing the info ?

i.e. I want a report based on a query, but I want to report on open requests by salesperson. A mistype in the Salesperson name means no data ! If they are forced to select from a Combobox then the accurate report is reflected...

Any ideas ?

 

[Joe4]

Re: Parameter Query Using DropDownList instead of typing inf

You can do this, but it requires a little Form creating and VBA writing.

You can create a Form where the user selects the options, and clicks a command button to process/run. This button builds the SQL statement needed to run the query.

To see what the SQL statement should look like, create the query, and change the view to "SQL View".

 

[Joe4]

Re: Parameter Query Using DropDownList instead of typing inf

Here is a link that may help you get started. There is a good link in there with an example:
http://www.accessvba.com/showthread.php?s=&threadid=7242&highlight=create+selection+form

 

[traversd]

Re: Parameter Query Using DropDownList instead of typing inf

Jmiskey,

Many thanks, I have had a look at the example link and will try and download the example when the boss goes for his next cuppa !

Thanks Again !