Hi
I have created a form with two drop downs. What I want to do is select a report name from combo1 then a filter value from combo2. The source for both combo boxes are separate tables.
I have a table with the seven report names (ReportTbl) which is source for combo1 then a separate table of departments in (DeptTbl) which is source for combo2,
I have a button control for which I was hoping to code an onclick event, which would open the selected report with the selected filter.
However, I'm not sure how to code this, if it is in fact possible, as part of the codes would be dynamic (changing dependent on the selected values in the combo boxes).
In essence, I want to select a report in combo1 and a department in combo2 with a button which will create that specific filtered report.
Is this possible? If so, any help in coding it would be appreciated.
I have created a form with two drop downs. What I want to do is select a report name from combo1 then a filter value from combo2. The source for both combo boxes are separate tables.
I have a table with the seven report names (ReportTbl) which is source for combo1 then a separate table of departments in (DeptTbl) which is source for combo2,
I have a button control for which I was hoping to code an onclick event, which would open the selected report with the selected filter.
However, I'm not sure how to code this, if it is in fact possible, as part of the codes would be dynamic (changing dependent on the selected values in the combo boxes).
In essence, I want to select a report in combo1 and a department in combo2 with a button which will create that specific filtered report.
Is this possible? If so, any help in coding it would be appreciated.