S
suzy
I used the wizard to create a switchboard with 5 buttons (1 per region)
Each switchboard item uses it's own macro to open a "Report Form
which right now has 1 combo box which is a list of report names.
I'm trying to use the 1 Report Form and filter the combo box by region
I have a macro on each switchboard item to Open Form and Apply Filte
(using the filtered query name). The record source on the Report For
and the combo box uses the select query that has a complete list.
can't get the macro to apply filter to the combo box when the Repor
Form opens. Please help. Thanks
Each switchboard item uses it's own macro to open a "Report Form
which right now has 1 combo box which is a list of report names.
I'm trying to use the 1 Report Form and filter the combo box by region
I have a macro on each switchboard item to Open Form and Apply Filte
(using the filtered query name). The record source on the Report For
and the combo box uses the select query that has a complete list.
can't get the macro to apply filter to the combo box when the Repor
Form opens. Please help. Thanks