C
Candi via AccessMonster.com
Hello,
I am trying to link the subreport and report in the Master/Child Links
properties. It is linked correctly, however when the main report runs, I
get 6 windows requesting the same parameters. I am trying to find a way in
VBA to set the parameter based on what the main report's parameter is (the
parameters are the same for both reports each time it is run).
This is what I have but it keeps erroring out.
Private Sub Report_Open(Cancel As Integer)
Static intCallCount As Long
If intCallCount = 0 Then Me.[Month Year] = "Month Year"
intCallCount = intCallCount + 1
End Sub
The first I am trying to set the parameter for the main reports query so
the subreport will use the same query.
Can anyone help?
I am trying to link the subreport and report in the Master/Child Links
properties. It is linked correctly, however when the main report runs, I
get 6 windows requesting the same parameters. I am trying to find a way in
VBA to set the parameter based on what the main report's parameter is (the
parameters are the same for both reports each time it is run).
This is what I have but it keeps erroring out.
Private Sub Report_Open(Cancel As Integer)
Static intCallCount As Long
If intCallCount = 0 Then Me.[Month Year] = "Month Year"
intCallCount = intCallCount + 1
End Sub
The first I am trying to set the parameter for the main reports query so
the subreport will use the same query.
Can anyone help?