Change/select record source of subreports

[TerriLynnG]

Hello,



I have a database with a table for current information and another that is appended at the end of each month to store history.

I then built queries to give the info I need for subreports...separate ones for each table.

I built an unbound report with the multiple subreports for the current info...

My question...is it possible to change the record source of the subreports from the current info queries to the history queries, depending on a user selection, or do I need to create another report with subreports for the history queries?

I am trying to get away with not creating another 12-15 subreports.

Any help would be greatly appreciated.

Terri

[June7]

I use the Open event of report to set RecordSource.

Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Nz(Me.OpenArgs, Me.RecordSource)
End Sub

However, I have never tried to set subreport RecordSource.

[tstoneami]

Private Sub Report_Open(Cancel As Integer)
Static intCallCount As Long
If intCallCount = 0 Then Me.RecordSource = "qryTest-B"
intCallCount = intCallCount + 1
End Sub