Drop down for query Selection...How

[rickmason]

Hi All,
I have reports that use queries that a user needs to put in a location such as ER, CCU, POST PARTUM, Etc They have asked if there is a way to have a drop down box to select the location instead of typing it out in the parameter query. If someone could shed some light on this, I would appreciate it. I think one issue will be that 90% of the data in the DB is imported therefore the departments are not stored in their own table(??) When I ran a "Make Table" query with just the departments, it listed many duplicates due to many employees working in certain departments.....not sure if there is much I can do at this point. Tanks in advance!!

 

[Remou]

You can use Select Distinct in creating your table. Right click in the Query Design Window and choose Unique Values, under Properties.
There are many example of using a form to provide criteria. Basically, you need a form with one or more combos, a button to run the query and a query that references the form on the citeria line, like so:

[tt]=Forms!frmCriteriaForm!cboLocation[/tt]

 

[rickmason]

Hi Remou, Would you by any chance have an example of the process of the screen? Thanks

 

[Remou]

Do you mean

http://support.microsoft.com/kb/304428/

?