Generating a report from info in a combo box

[sarahchadwick74]

Hello,
I hope you don't mind another novice question. Iam trying to create a report of "current" projects. The status of each project is selected from a drop down combo box on a form. At present I can only seem to generate a report of all statuses, then select to present them in an order. But the report is huge as its all 5 statuses. Is would really like a report of just "current" and on "hold" projects and ideally just to those belonging to one team at a time (another drop down combo box). Your advice as ever would be appreciated. Sarah.[emoji4]

[ItsMe]

A parameter query may be a solution for you. You could base the query on your form and the combobox control.

I, generally, stay away from parameter queries because, in a normal sized DB, you will end up with way too many query objects. So, other options may be to incorporate SQL within VBA to manipulate query defs.

To create a parameter within your query object, you can add criteria to the appropriate field. If you start by typing, "Forms" (without quotes) into the criteria field, intellisense may be able to help finish the criteria expression (using the Form name and combobox name)