drop down box for criteria 1

[gray78]

Currently I have a report that when I run it, it askes for criteria(facility). I would like to replace this with a dropdown box, is this possible and if so....how?

Thanks

 

[lupins46]

You would have to create a form containing a combo box which listed your options and set your report query to use that form/combo as the parameter.

 

[gray78]

did not work, can you explain with a bit more detail.

Thanks

 

[lupins46]

If you create a form containing the combo, the query parameter (criteria cell) then refers to the combo:

forms!myformname!mycomboboxname
If you open the report from a button on the form this ensures the form is open when the report runs.

What does 'not working' mean?

 

[gray78]

still cannot create the dropdown box to select facility from

 

[grande]

It should be right there on your toolbox, just below Toggle Button, and just left of ListBox.

I don't think you're understanding what he's saying. To make a combo box, you have to forget about using the easy parameters that Access does automaticly. You'll have to acutally manually (ie, use Wizards to) make a form.

If you need help on how to make a form, or how to setup the combo box, reply.

-------------------------
Just call me Captain Awesome.

 

[gray78]

i have done everything and still when I run the report i do not get a dropdown list with the parameter i want. The reprot just runs with all data

 

[lupins46]

You must run the report using a button on the form containing the combo box.
You open the form, choose the value from the drop-down list and then click the button to run the report.

 

[dhookom]

Gray78,
Consider reviewing this tutorial

http://www.fontstuff.com/access/acctut08.htm.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CptCrusty1]

It sounds kind of like the report is being run from a query and in the QBE for the query the Facility column doesn't have the location of the column selected. I.e., If your pulling from a Teachers table, (Name,Facility), in QBE, Facility is in the columns to display, however, the location of facility is not, therefor QBE is asking. Am I close?