using a subreport value in another subreport

[Manoj Jiwatramani via AccessMonster.com]

i have a report which contains two subreports - subreport1 and subreport2.

subreport1 has a textfield1.
subreport2 has a textfield2.

i want to show textfield1 + textfield2 in subreport2.

how can i do that ?

please help me or if there is already a thread existing which answers my
question, please direct me to that thread.

thank you.

 

[Allen Browne]

You will have to find another way to approach this.

A subreport may have several records. Access works through the records and
calculates how subreport1 should look. It then works through subreport2's
records calculating how it should look. When it's working through
subreport2, there is no such thing as a 'current' record in subreport1, so
there is nothing you can ask it to sum.

Perhaps you can use DLookup() or some other approach to get the value you
need.

 

[jiwatramani via AccessMonster.com]

thanks alot.
but earlier i have tried to show textfield1 + textfield2 in the main report.
and it works properly.

i dont know how this is not working.

could you tell me something about DLookup.

 

[Allen Browne]

Here's some info on DLookup:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html