this is about a SUBreport
Depending on whether or not a bit of info is also included in the subreport, I want a control to be placed at one position or another.
Consequently, I added this code:
Code:
Private Sub Report_Load() varInclJobNo = DLookup("[InclJobNo]", "tbeFixtureSchedulePrintOptions")
If varInclJobNo Then
Me.lblftrDate.Top = 0.5382 * 1440 '1 inch = 1440 twips
Else
Me.lblftrDate.Top = 0.3785 * 1440
End If
End Sub
If I just check the code by opening the subreport alone, it "seems" to work;
but when it is opened as a child of the main report... no
... I thought that maybe it wasn't unloading (when the parent report was closed... so the child subreport never actually reloaded (?)).
So I added this:
Code:
Private Sub Report_Unload(Cancel As Integer)
DoCmd.Close acForm, Me.Child_footer.Name
End Sub
but that didn't work, either
Then i tried another half dozen or so other things...
At this point, i'm fishing in the dark; and any suggestion would be greatly appreciated in advance,
mark