View Macro Result in subform

[rato999]

Hi,
I have created a macro name "MonthwiseRep" to view select query result in pivottable view which works fine when I run the macro.
But problem occurs,
if I wish to populate subform on a click of a button that I have on the main form with the same macro results as "MonthwiseRep" in pivottable view.

I tried the following code for click event of the command button but it didn't work



Me!Child21.SetFocus
DoCmd.SetWarnings False
Me.Child21.SourceObject = MonthwiseRep
DoCmd.SetWarnings True
Me.Child21.Requery

Thank you for your time and help in anticipation.
Cheers !!

[RuralGuy]

Here's a link you may find useful: http://www.mvps.org/access/forms/frm0031.htm