Access Graphs displaying old data instead of new

[PrerYDoG]

I am having a problem diplaying graphs in Microsoft Access. I currently have a Form that updates a table using SQL Insert Statements. The table has 4 fields in it, and will update with anywhere between 100 and 1000 records, depending. After the table is updated from date range and line # inputs on the form, a report is opened displaying a line chart. If I then close the report, change the line number and re-run the code and pull up the report, it's displaying the OLD data (which is NOT in the table, the table contains the new data, but the graph is the old graph).

For the life of me I haven't been able to figure this out. I have this happening on multiple PC's on multiple different databases with different graphs (some bar graphs, some line graphs). The data in the tables update correctly, the code that updates the tables works, but the graph will display incorrectly. Often after closing the graph and re-running the code to re-open the graph will get it to display correctly. Also, if I flip the graph to design mode and back to report mode I will get the correct data displayed.

ANY HELP would be appreciated.


Mark

 

[PrerYDoG]

Update: I just did some more work on this and noticed that if I PRINT the graph, it prints the correct data, but is DISPLAYING incorrectly. This means that what I'm seeing on the screen, and what comes out of the printer when I hit the print button are DIFFERENT.


Makes it even more mind boggling to me.


Mark

 

[AArt]

I have the same problem. My graph is based on a query, with parameters of "Between (date()- 14) and (date() + 56)". The graph displays dates beginning 12/31/01 on the screen, but the query and the printout show the correct March date.