I have created a report and placed a Microsoft Chart 6.0 ActiveX object in it, and I was attempting to link the chart to a query result set...
I've gotten to the following point with my code:
Dim objChart As Chart
Set objChart = Me.MyChart.Object.Application.Chart
objChart.DataTable = "Qry Milestones by Program 04"
And on the set objChart line I keep getting an error message that states:
Run-time error '2771':
The bound or unbound object frame you tried to edit doesn't contain an OLE object
Please help - The query results contain data categorized and totaled by month, and I need to use this control so that I can have a combonation chart with bars, stacked bars, lines, and area graphs for different series of data.