Dynamic Report with VBA - Setting RecordSource

[lotharious]

I am trying to make a report for balancing transactions by a PO #. The data I need is in 4 different tables based on the transaction type in the primary field. I have got the data in my VBA but do not know how to put it into the reocrdsource of the report. I will not put this in a temporary table for just this report.

So, in VBA, how do I go about setting recordsource with the data that I have put together in my code?

 

[HitechUser]

You can't use recordsource... But this may get you closer... VBA code

 

[lotharious]

Thanks for the reply...
That should help when I get back to working on it later this week.

Also have another forum to look through when I have questions!!