S
Skunk
I think this is simple, but not for me - an amateur.
On a form I have a button that calls a date selector form where the user
enters the desired date range. The report is called for the date range the
user specified.
Button code:
DoCmd.OpenForm "9frmSelectorDate"
Forms![9frmSelectorDate].Visible = True
Forms![9frmSelectorDate].txtFormNum = 12
Date Selector Code:
...elseIf Me.txtFormNum = 12 Then
stDocName = "DesiredReport"
strSql = "[EnterDate] >= #" & CDate(Me!txtStartDate) & "# AND
[EnterDate] < 1+ #" & CDate(Me!txtEndDate) & "#"
Me.Visible = False
...
Everything is AOK for the report(s).
However, I wish to run several disparate activity reports using the same
date range.
How would I accomplish this with this -- or similar -- setup?
Thanks in advance,
On a form I have a button that calls a date selector form where the user
enters the desired date range. The report is called for the date range the
user specified.
Button code:
DoCmd.OpenForm "9frmSelectorDate"
Forms![9frmSelectorDate].Visible = True
Forms![9frmSelectorDate].txtFormNum = 12
Date Selector Code:
...elseIf Me.txtFormNum = 12 Then
stDocName = "DesiredReport"
strSql = "[EnterDate] >= #" & CDate(Me!txtStartDate) & "# AND
[EnterDate] < 1+ #" & CDate(Me!txtEndDate) & "#"
Me.Visible = False
...
Everything is AOK for the report(s).
However, I wish to run several disparate activity reports using the same
date range.
How would I accomplish this with this -- or similar -- setup?
Thanks in advance,