Report w/ date range issue..

[kalebson]

I have a report that has 2 subreports in it. In order for the subreports to run you have to enter a date range that come from the query. Is there a way that I can set an [Event Procedure] so that it sets the date range the same for both subreports?

Something like this..this doesnt work but something similar would be great...


Private Sub Report_Open(Cancel As Integer)

Me.ConversionPctPHX.[enter start date] = Me!ConversionPctSTP.[enter start date]
Me.ConversionPctPHX.[enter end date] = Me!ConversionPctSTP.[enter end date]


End Sub

 

[pbaldy]

The more common solution is to have the user enter the dates on a form, and have the queries look there for them.