I am trying to create a chart on a form in Access. This morning I was able to do it. Now the query that I used to create this chart has changed and there is an additional category to chart.
I tried starting from scratch with a new report, and I still keep getting the sample data. When I review the report in print preview, it has the correct data. However when I try to open or edit the object from design view, all I get is the sample data. I need to make changes in the colors, text size so I need the real data.
I also saved the report several times and closed and reopened Access without any luck.
Anybody know what is going on and how to fix this?
I am using Access 2000.