Active form

  • Thread starter Thread starter Boss
  • Start date Start date
B

Boss

Hi,

I am preparing a MIS which has lots of pivot-forms.

I am thinks of exporting them to excel and viewing graphs of them using
below code

DoCmd.OpenForm "test", acFormPivotTable
DoCmd.RunCommand acCmdPivotTableExportToExcel

DoCmd.OpenForm "test", acFormPivotTable
DoCmd.RunCommand acCmdPivotChartView

This code works for the form "TEST".

Please help me so that it works for the active form. If this happens i will
have two button to "export to excel" or "view graph". user would just click
his report and do what he likes.

Thanks!
Boss
 
No.. I amlooking for some code which works on the active form.

can i use

me.activefrom

help me get solve this issue.

Thanks!
Boss
 
Back
Top