(this may belong under programming?)
I have a report with several layers of subreport
on a 3rd tier subReport I had these lines of code
at the top:
Code:
Option Compare Database
Dim mdblNoteNumber_detail As Double
at OnOpen
Code:
Private Sub Report_Open(Cancel As Integer)
mdblNoteNumber_detail = 1
End Sub
at DetailPrint
Code:
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
txtInstallationNoteNumber = mdblNoteNumber_detail
mdblNoteNumber_detail = mdblNoteNumber_detail + 1
HOWEVER,
Every time the report prints, the first record does not show a value for txtInstallationNoteNumber
all of the subsequent records correctly do...
I thought:
move the variable definition to the top level report (declaring it public)
Code:
Option Compare Database
Public mdblNoteNumber_detail As Double
and in its report open.. I'd move the code
Code:
Private Sub Report_Open(Cancel As Integer)
mdblNoteNumber_detail = 1
End Sub
yet when the subreport opens...
it has no value for mdblNoteNumber_detail
as always, any suggestions would be greatly appreciated in advance,
m.