Subreports

[kram327]

How can I consolidate all subreports in one main report wherein I have 3 subreports?

There should only one subreport be shown every report, that is, a certain value of a textbox will determine what subreport it will display. After that, primary key will determine what exact report will be displayed in the subreport.

Hope you will able to help me. Thanks in advance.

 

[batteam]

You could try laying all three subreports on top of each other on your main report. Make them all invisible via VB code on Report_Open event(in the main form)then add code there to make the one you want visible based on the value of the textbox in your main form. Use IF..smts or better yet, a Select Case statement.

Hope this helps. Good luck.