Report and Subreport Interaction

[Gman]

I have a report with one subreport, they are linked with a master/child.

The main report is linked to a query, and the subreport is continuous report, so I could have no records or I could have 10 records in the subreport.

What I am trying to do is in my main report, I have 3 unbound textboxes stacked, they are named TB1H, TB1M, and TB1L. I also have ten sets in columns. The second column is named TB2H, TB2M, etc.

Now, what the first goal is, if there are no records in the subreport, then I want to hide all of the unbound textboxes in the main report. If there is only one record in the subreport, then show TB1H, TB1M and TB1L, and then hide all the other unbound textboxes. If there is two, then show first and 1 & 2, and hide 3 though 10.

Now second, if there is one record in the subreport, the subreport will have three fileds, say they are tb1, tb2 and tb3. I want to set the value of the unbound textbox TB1H in the main report to the value of tb1, then set TB1M to tb2, and TB1L to tb3.

And if there are two records in subreport, then the TB2H, TB2M, and TB2L need to set equal to the second record values in tb1, tb2, and tb3 of the subreport.

I have tried a bunch of things,

If I cycle through all the controls of the subreport from the onformat event of the main, I get errors, and I do not get all of the records, only the first.

If I cycle through all the controls of the subreport from the onformat event of the subreport, then I cannot set the textboxes in the main report.

I seem to be only able to set the values of the unbound textboxes from the onformat or print format in the main report.

I need some help and direction, can this be done.

I would post my database, but it is to large, and very tough to make smaller.

Thanks

 

[wiklendt]

I have tried a bunch of things,
...
I would post my database, but it is to large, and very tough to make smaller.

have you tried:

a) normalising your data
b) compact/repair + compress into zip...

?

 

[Gman]

I have attached the database,

I removed a lot of tables and queries, but have the report and subreport that I need help with.

You can see that when you open report, the subreport is linked byt master/child, so the I get the coreects records in the subreport.

please proivde any help or direction,

Thanks

 

[Gman]

I have heard back from anyone regarding the above questions. Does anyone have any insight on the how to accomplish this task.

Thanks