Linking Subreports and Reports

  • Thread starter Thread starter Candi via AccessMonster.com
  • Start date Start date
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'm not sure I understand you question. If you want the user(s) to enter
criteria to filter a query, use reference(s) to controls on forms. Don't use
parameter prompts.
 
Back
Top