Every week I have to print this particular report for job costs, individually for each job. I am tired of having to type the job number and name and the weekending date.
I have used this routine and it works if I set my own title. Here is the code
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page = 1 Then ' no need to do it more than once
Me.Caption = "PostingSum" & Forms!frmRptAnyWeekbyJob2!txtWeDate" '''''PostingSum is just a name I am giving the report. TXTWeDate is a text field created to format the date with dashes.
End If
End Sub
Now it created a textbox for the job number and Name which is selected from a combo from the below listed form
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page = 1 Then ' no need to do it more than once
Me.Caption = Forms!frmRptAnyWeekbyJob2!txtJobNoName" - " & Forms!frmRptAnyWeekbyJob2!txtWeDate"
End If
End Sub
I need to know in which format I have to code the JobnoName for it to work