I pass the name of the report in its caption using the Open Args. But, I need to pass two items in open args. One to dynamically change the report title and an argument to change the sort order. Right now, I pass the caption, but how to I add a second argument?
DoCmd.OpenReport strReportName, acViewReport, , strFilter, , strReportCaption
Private Sub Report_Open(Cancel As Integer)
Me.lblTitle.Caption = Me.OpenArgs
Need to add in the Report_Open event
Me.OrderBy = Me.OpenArgs
Me.OrderByOn = True
Will post as another question as you did answer the one I asked.