Report based on combo box selection on form

[Sudha]

Hi,

I have a form with a combo box where the user selects the required Project.
I have a Report button on the form. how do I get the report based on the selection in the combo box. currently my report shows all the Projects. I want a report only for the project which is selected.

 

[maxmangion]

you should base your report on a query and then use the combo box selection as a criteria for your query.

i.e. in the criteria field of your query put [Forms]![FormName]![ComboSelectionName]

 

[Sudha]

Thank you!

 

[maxmangion]

you're welcome