Susan Harkins
ssharkins at bellsouth.net
Sun Aug 8 15:48:44 CDT 2004
The following procedure prints a "Missing Record" label in a subreport when there's a missing AutoNumber value -- I've based this particular example on the Products table in Northwind. It works fine, except for one thing -- it prints the subreport label text at the beginning of the Detail section -- before the first record. For the life I've me, I can't seem to shut it up! The subreport is positioned at the beginning of the Detail section, just above the actual controls. Susan H. 'Track record ProductID values. Public lngMissingRecordFlag As Long Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) 'If current record isn't one more than flag, print warning. Dim lngRecordCounter As Long lngRecordCounter = ProductID.Value If lngMissingRecordFlag = (lngRecordCounter - 1) Then Report.rptMissingRecordsub.Visible = False ElseIf lngMissingRecordFlag <> (lngRecordCounter - 1) Then Report.rptMissingRecordsub.Visible = True End If lngMissingRecordFlag = lngRecordCounter End Sub