Z
Zoe
I have 2 combo boxes on my form. I want to be able to run a specfic report
based on the selections from both combo boxes.
The first combo box is Combo99 and contains these values:
1 Month
3 Months
6 Months
9 Months
12 Months
The second combo box is Combo105 and contains these values:
Agent
Agent and Branch
Provider
Provider and Branch
(these are only a few - there are actually 13 options).
(I created the combo box from a table tblReports1 and the column name is
Sort by)
I would like to have one command button that would open the correct report
based on the selection. For example:
If 1 Month is selected from Combo99 and Agent is selected from Combo105, the
report Agent Totals - 1 Month opens.
If 3 Months is selected from Combo99 and Provider is selected from Combo105,
the report Provider Totals - 3 Months opens.
I think that I am on the right track but I don't know how to tie it together
on the command button.
Suggestions/Solutions are greatly appreciated!
Thanks,
Zoe
based on the selections from both combo boxes.
The first combo box is Combo99 and contains these values:
1 Month
3 Months
6 Months
9 Months
12 Months
The second combo box is Combo105 and contains these values:
Agent
Agent and Branch
Provider
Provider and Branch
(these are only a few - there are actually 13 options).
(I created the combo box from a table tblReports1 and the column name is
Sort by)
I would like to have one command button that would open the correct report
based on the selection. For example:
If 1 Month is selected from Combo99 and Agent is selected from Combo105, the
report Agent Totals - 1 Month opens.
If 3 Months is selected from Combo99 and Provider is selected from Combo105,
the report Provider Totals - 3 Months opens.
I think that I am on the right track but I don't know how to tie it together
on the command button.
Suggestions/Solutions are greatly appreciated!
Thanks,
Zoe