Design View vs Form View
in [General]
|
From: Tom Wickerath AOS168b AT comcast DOT on 16 May 2010 22:39 Bill, > Could you please be more specific in what I should do to correct the > problem. The behavior you are seeing is by design. See this article: http://office.microsoft.com/en-us/access/HP051887151033.aspx Click on the "+" sign next to this topic: + I see sample data instead of my data after creating a chart. In form or report Design view, the chart shows sample data when you first create it. To see current data, switch to Form view or Print Preview, or close the form or report and then open it. Read Al's answer again. He showed you how to update the values. However, you would need to go through this manual process each and every time you need to see the most current data in design view. Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ __________________________________________ "Bill" wrote: Al: You are correct in your assessment of what is happening with showing old data in design view and current data in form view. Could you please be more specific in what I should do to correct the problem. May be a step by step solution. Thanks, Bill __________________________________________ "Al Campagna" wrote: Bill, Your probably saying the design data displays an earlier design results, but the form view graph data is correct. The graphs have acted that way for the past Access versions as well. I think the Graphing in Access is borrowed from Excel, and does not update in design view as it should. One way around that, is to run the query behind the graph in design view, and copy and paste the query results into the graph's associated excel spread sheet. That will "smack the graph up side the head", and get the latest values to show in design... as well as form view. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." __________________________________________ "Bill" <Bill(a)discussions.microsoft.com> wrote in message news:6E1FE22D-D0AE-44CD-A648-635869CA55AF(a)microsoft.com... In Access 2007, I have a graph in Design View which shows differently in Form View. In other words, the information that is plotted in the graph shows differently in the two views. Why is this? Thank you, Bill |