View Full Version : Report parameters


erinnicole
01-29-2003, 09:41 AM
I am a beginner.

I have a report that has a parameter. In the table the record is a drop down list. However, to run the report based on that record, the parameter is a text box and I would like it to be the drop down list.

How can I make the parameter a drop down list?

Hayley Baxter
01-29-2003, 09:46 AM
Add a combo box to your form then lookup the table that your drop down list is stored in. You can then open your report based on the selection you make.

In the query you would add criteria to look to the combo box for an entry

[forms]![yourformname]![yourcomboboxname]

If your still struggling do a search on my name and you should find a sample of this. If not let me know and I can send it onto you.

Hay