Hi all,

I have a main report that calls a subreport. If I just use the wizard and have nothing complex, it works fine. However, I have to dynamically populate the report because my query can produce a different number of columns each time. I have used VB code in the subreport to do this and it works fine when I call the subreport alone. When I call it from the main, it does not put the values in. Has anyone had this happen? Where should I call the report from the main? I assume that I will have to call it from VB code and not rely on the wizard.

Thanks

Did you try the On Open event for the subreport? (Go to the Report Property Sheet for the Subreport. The first time you click on the subreport in design view you get the subreport properties, the second time the Report Properties come up. You can get to the On Open from there)

Yes. I put the header creation in the open event on the subreport and it works fine. If I try to move the values into the textboxes, I get a error though. I think it is because the query has not run yet on the open event. I tried putting it into the on Activate event and it works if I just run the subreport. It will not run from the main report though(I only get the headers and the text boxes where the totals are suppose to go are blank). I need to find a place in the main report to run it. If I can get the VB command to run the subreport, I was going to try calling it from the main after the main report does its processing. I have looked on google and in my books to see if I can find the VB code to call a subreport but can't find it.

Thanks