E
ELS
I want to create a form that will allow the user analyze
data by clicking buttons to modify a crosstab query with
different parameters, i.e. click 'Monthly' to see monthly
columns, click 'Quarterly' to see quarterly, etc. I
found a way to change the crosstab using QueryDefs at
http://support.microsoft.com/?kbid=255782 and got it to
work. I'm using a child object on the form to display
the query. The problem is, I have to close and open the
form to have it display the modified query. I've tried
Me.Recalc, Me.re(everything else) as well as Forms!myForm!
myChild.Requery but nothing works(although the last line
leaves the rows and columns but does changes the data
to '#Name?').
Any ideas how to update the form at runtime or a better
way to accomplish my goal would be greatly appreciated!
Thank you in advance.
ELS
data by clicking buttons to modify a crosstab query with
different parameters, i.e. click 'Monthly' to see monthly
columns, click 'Quarterly' to see quarterly, etc. I
found a way to change the crosstab using QueryDefs at
http://support.microsoft.com/?kbid=255782 and got it to
work. I'm using a child object on the form to display
the query. The problem is, I have to close and open the
form to have it display the modified query. I've tried
Me.Recalc, Me.re(everything else) as well as Forms!myForm!
myChild.Requery but nothing works(although the last line
leaves the rows and columns but does changes the data
to '#Name?').
Any ideas how to update the form at runtime or a better
way to accomplish my goal would be greatly appreciated!
Thank you in advance.
ELS