A curious note found in report's code sheet

B

Bill

' Not exactly related to the Header formatting, but
more to the report opening process, the Where Clause
' passed to the DoCmd.OpenReport isn't available
to this code sheet until the time we're about to format
' the header section...... I don't know why.

The above note was found in the "ReportHeader_Format"
sub. The only code in the sub is:

If Duplex = True Then
Inc = 3
PgNo = Mid(Me.Filter, InStr(Me.Filter, "R") + 1, 1) - Inc
Else
Inc = 1
PgNo = 0
End If

Which has nothing to do with the header formatting, as
the note implies. So, my question is: What is the answer
to the question posed by the code's author, "I don't know
why". The implication is that the code was originally included
in the OnOpen sub and the "filter" expression wasn't yet
available.........I'm just guessing that was the case?

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top