erport from drop-down menu

[jesbase]

Greetings All!!

My first post here - hoping I get great responses and help liek I have had from other online forums!

Heres what I'm trying to do. I have a drop-down menu that selescts different items from a table. I want to run a report that uses the selected name form the drop-down as the filter. I can make the drop-down, I can make the report, but dont know how to tie the two together.

Anyone help with this?

 

[Nouba]

put this code i.e. behind a Click Event of a button and adjust the names.

DoCmd.OpenReport "YourReport", acViewPreview, , "[YourItemFieldInReport]='" & Me.YourDropDown & "'"

If your filter depends on a numerical value remove the single quotes.