Dynamic Reports

[bkessinger]

Good Morning all:

Is it possible to create a report that can have multiple (not at the same time) data sources? I would like to have the report select the data source from a dynamic list box of inputs. Any and all suggestions would be appreciated and most helpful. TIA.

Bill K.

[HansV]

As long as the data sources have the same field names, that should be possible: you can set the Record Source of a report in its On Open event, like this:

Code: Select all

Private Sub Report_Open(Cancel As Integer)
  Me.RecordSource = Forms!frmSelect!lbxDataSources
End Sub

where frmSelect is a form and lbxDataSources a list box on that form listing the names of the data sources.

[JohnH]

As long as the data sources have the same field names

Or as in the example of Dynamic Cross tab reports the Control Source of individual controls on the report is set when the report is opened.

[bkessinger]

Hey John,

Thanks for the reply. I think I found what I need on Roger Carlson's web site. He's got a few excellent examples.

Bill K.

[HansV]

Yes, Roger's Access Library has many useful sample databases.

[ChrisGreaves]

... you can set the Record Source of a report in its On Open event, ...

Oh great. Just Great.
Now you guys have started to anticipate my Access questions ..... and

[Wendell]

That's because we've already asked the same question and our head against the wall, or asked somebody till we figured out the answer - most of the time hopefully.