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!

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

Communication between two subreports

Status
Not open for further replies.
rushdib

rushdib

Programmer
Jun 12, 2001
203
US
I would like to know how to pass values between two subreports which are inside a main report using VBA? I tried "Reports![subreportname]![somevalue]" it gives an error.

Thanks
 
Sort by date Sort by votes
Can you explain what you are trying to do? It's not clear from your post. Examples are helpful!

Joe Miller
joe.miller@flotech.net
 
Upvote 0 Downvote
Ex. If there is a field named 'Total' in subreportA, and I want to receive that field value in subreportB using VBA when the reports formats or prints.
 
Upvote 0 Downvote
Here's the syntax you need:

=[Reports]![MyMainReportName]![subreportA].[Report]![MyTotalTextBox]

Joe Miller
joe.miller@flotech.net
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
447
dhookom
dhookom
Lhuffst
  • Locked
  • Question
no data on subreports 1
Replies
5
Views
114
Lhuffst
Lhuffst
NeilT123
  • Locked
  • Question
Is it possible to join two fields and make the resulting fonts different colours?
Replies
2
Views
117
MajP
MajP
earljgray
  • Locked
  • Question
One Subreport and Many Subreports in One Report
Replies
3
Views
101
dhookom
dhookom
Pack10
  • Locked
  • Question
subreports repeat in the main form
Replies
2
Views
84
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top