Active form

[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

 

[Jim Burke in Novi]

You refer to a form's name with Me.Name, if that's what you're looking for.

 

[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

 

[Douglas J. Steele]

Screen.ActiveForm