Insert Chart button greyed out - Access 2007

[rwp289]

I want to place a chart on form that is based upon a query. But the "insert Chart" button in the contols ribbon is greyed out. I have tried blank froms that were bound and unbound. Not luck



Ideas?

[RuralGuy]

Have you used the Design Ribbon to first place a Chart Object on your form?

[rwp289]

The chart button on the design ribbon is the one that is greyed out. I can't select it or drag it to the form. Other controls (listbox, combobox, etc) are all available but the 'insert chart" control is not.

[RuralGuy]

Hmmm...what references do you have included in your project?

[rwp289]

Visual Basic for Applications
Microsoft Access Library 12.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.5 Library
Micorsoft Office Web Components 11.0

Is there one for charting?

[RuralGuy]

I have something called:
Microsoft Office 12.0 Access database engine object Library
...that is checked in my References.
Have you applied all of the Office 2007 Service packs and HotFixes? Have you tried refreshying your references? (Uncheck an item and OK out and then go back in and check it again)