I have a form with 2 comboboxes and a command button.
Combobox 1 is irrelevant for this question.
Combobox 2 is for pulling a list of all reports.
Command button is for generating the report from the choices in the comboboxes.
Combobox 2 has this imbedded query in the Row Source: