Drop down box in a query 2

[dporrelli]

I am doing a report which the user enters a start date and an end date for a filter for the report, this was done easy enough using [] with the user entering the data, I also want to be able to filter it on another field,but I'm trying to make this a drop down rather that user entry (you know how some users can not spell and say that the prog is not working anymore!!!!!!!)

Thanx

 

[M8KWR]

So when you run the report, i take it you have 2 parameters pop up for user entry, and now you want another one displaying a drop down...

The best way to do this would be instead of having the parameter pop up, have a form, with the 3 fields on you need

Start date, end data + the additional one.

This way you can have a drop down.

All you would need to do is in your query alter the code to something like:

[forms]![Name_of _Form]![Name_of_fields]

Instead of opening the report directly, oopen the form, then on the form you would have a button saying preview/print etc...

hope this helps. If you are unsure of what i have said please let me know.

 

[jaydeebe]

This link will take you to a great tutorial for creating custom parameter queries using forms with combo boxes.

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

There are also many other useful tutorials on this website.

Jaydeebe BSc (hons)
MCSA 2k
MCSE 2k