Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA Code in SubReport Executed But Has No Affect In Parent Report

Status
Not open for further replies.

iamdman

IS-IT--Management
Jun 4, 2007
8
0
0
CA
Is this by Microsofts' design?

My sub-report contains:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Me.Parent.[PageBreak].Visible = RecCount Mod 10 = 0

End Sub

I put a breakpoint above and the code is being executed but there is no affect in the parent form where the pagebreak is lives. No error is generated either. I even tried to set the caption of a label on the main report from this subroutine, again nothing happens.

Thoughts?

Thanks,

iAmDmAn
 
can you use absolute names instead?

reports("reportName").[PageBreak].Visible

--------------------
Procrastinate Now!
 
I will give that a shot, I am not optimistic.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top