When I run the report I'm always prompted for the parameters of the stored 
procedure. 

The gSite_no and gUser variables are global and set when the user logs 
into the app.

There is a master report with three sub reports. The open events are all 
the same except the sectionname parameter is different for each.  On sub 
reports, I can't change the recordsource during it's open event.  

Private Sub Report_Open(Cancel As Integer)
    Call MyScreen.FormatMilitaryDate(Me.RESULT_DATE)
    Me.InputParameters = "@pSite_No = " & gSite_No & " , @pUser_ID = " & 
gUser &  ", @pSectionName = 'MASTER'"
    Me.RecordSource = "dbo.spLIMS_LotResultReport"
End Sub

Need suggestions.

Thanks.