Prev: Shading Header / Footers and separating all rows with lines; weird whitespace
Next: Importing TXT files with delimiter
From: Jim on 23 Apr 2010 16:42
I have a report with the following code behind:
Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
If Format(Forms!frmCommission!cboStartDate, "mmyyyy") =
Format(Forms!frmCommission!cboEndDate, "mmyyyy") Then
Me.txtTitle = "Commission " & Format(Forms!frmCommission!cboStartDate,
Me.txtTitle = "Commission " & _
Forms!frmCommission!cboStartDate & " To " & _
Private Sub Report_Open(Cancel As Integer)
Select Case Form_frmCommission.optSource
Me.RecordSource = "qryCommInvUS"
Me.RecordSource = "qryCommInvCanada"
MsgBox "Select Report"
I need to change the title of the report to add either Canadian or U.S. to
the title depending on the Record Source, leaving the other criteria in
place at the same time.
Thanks for any help.