using main report as a reference for sub reports

[GaryPanic]

can this be done ?

Main report holds the information required - but in the sub report (of which there could be 10 of) I want the data from the main report

the report is split by currency then tax
and then up to 10 sub reprots off this (per currency per tax)

 

[vbaInet]

You can certainly reference a field in the parent report from the subreport. Depends on how things are setup though?

Maybe this link will help:

http://www.mvps.org/access/forms/frm0031.htm

Follow the "Not in these forms" section

 

[GaryPanic]

I'll read this - as doing the other way would be a real nightmare -
each report can have upto 10 sub's

and when I run the main report it should divide into 5-6 reports with x sub reports

thansk for the response

g

 

[boblarson]

Just remember - Sub reports are loaded before the main report, so basing something from the sub report on the main report may be problematic.

 

[vbaInet]

Good point Bob. Maybe the OP could explore a different approach, probably using GROUPING where possible.

 

[GaryPanic]

Just remember - Sub reports are loaded before the main report, so basing something from the sub report on the main report may be problematic.

Bugger...

I will look at this if it works all well and good

 

[GaryPanic]

Nope - stuffed going down this route -

Any ideas to run two seperate reports

my main report will filter (group by)
currency - I have currrency table with autonumbers on it and a tax table.

 

[vbaInet]

I don't follow. Could you elaborate? Surely if you have the Link fields setup correctly it will filter but you obviously know that.

 

[GaryPanic]

it was late when I typed this last night ....

i think I know what I want and how to do it - so i will muddle through (until i get stuck )

 

[vbaInet]

See how it goes. Good luck!