combo box shows relevant reports in subform

[kamle_b]

Dear all,

I have a form called frmNum. This form has one combo box. A combo box called cboView has value list of "Line A Early", "Line A Late", "Line B Early" and "Line B Late". Now i have created different reports for each of this list. I have got a subreport box on the form frmNum. What I want to do is when "Line A Early" is selected in cboView, subreport should display "Line A Early report"; if "Line A Late" is selected then "Line A Late report" should be displayed in subreport and so forth.

How do i go on about this?

Thank you in advance.

[PEB]

Dear all,

I have a form called frmNum. This form has one combo box. A combo box called cboView has value list of "Line A Early", "Line A Late", "Line B Early" and "Line B Late". Now i have created different reports for each of this list. I have got a subreport box on the form frmNum. What I want to do is when "Line A Early" is selected in cboView, subreport should display "Line A Early report"; if "Line A Late" is selected then "Line A Late report" should be displayed in subreport and so forth.

How do i go on about this?

Thank you in advance.

In Fact in SubForm/SubReport You can't see a Report created in the report section of your database!

This kind of reports are open with command like:

DoCmd.OpenReport reportname, A_PREVIEW

This command you need to put in After Update of your combo box for activating your reports!

I suppose that the reports are named as their names in the combo box so:
The full code is:

DoCmd.OpenReport Me!cboView, A_PREVIEW

Have a nice day!