Changing Subform Datasheet to PivotChart

P

polisci grad

I have a form that has a subform which displays the result of a query made on
a previous form. This query is created using DAO I believe, because I got
the code off of some developer website and it has DAO commands in it.

Anyhow, I would like to have the user click a button and change the subform
view to pivotchart. Also, if it is possible, for this pivotchart to remain
in the subform window.

Thanks,
 
Top