Why Pivot Chart changed to Form -- In Different Computer's Access

[Martin \(Martin Lee\)]

Button VBA:

Private Sub Command179_Click()
DoCmd.OpenForm "salesvol", acFormPivotChart
End Sub


I use ACCESS 2002, and saved the file as 2000 format. When I click that
button, the access will show a CHART ( not show a FORM)

However, when I copy the access file to other colleges's computer (they use
Access 2000), when clicked the button, the access show a FORM instead of a
CHART .


Why??? Is it the Access 2002 c.f. Access 2000 problem ? Or, other
problem I don't know?


Please help me.

Thanks!

Martin ( Martin Lee)

 

[TC]

In this artice on Access 2002:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart01/html/sa01f1.asp

immediately above the heading "New events", I see the following words:

"And the DoCmd.OpenForm method now accepts acFormPivotChart and
acFormPivotTable constants to let you open forms directly in these
views."

so I assume from that, that the acFormPivotChart option does not exist
in the previous version, Access 2000.

HTH,
TC (MVP Access)
http://tc2.atspace.com