Multiple parameters needed?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a report that contains 4 subreports and they all require the same
parameter value. Of course the parameter box pops up 4 times and I eneter
the same data over and over. Any suggestions how to do this would be
awesome. Thanks
 
Have the user enter the parameter value into a text box on the form from
which you call the report . Then, the query/report can simply refer to it as:

[Forms]![Form1]![Text1]

instead of [Enter customer] or whatever.

If you do this, make sure that Text1 is not null before calling the report:

Private Button1_Click()
If IsNull(Text1) then
Msgbox "Enter the parameter first"
Exit Sub
Else
Docmd.OpenReport "MyReport"
End If
End Sub
 
Back
Top