wish helps you The problem isn't the repainting of the graph. Most likely, the subform that you are using is retrieving data from a query or table. You must update the values on the "datasource" object, which is providing the subform data (either a query or a table). Then, re-query the graph object in the mainform.
How do I make a Microsoft Word application appear on top of the Microsoft Access for which instantiated it?
I hope this helps you . I have a Microsoft Access form which will display a Microsoft Word app with a blank document when a particular button is clicked using the following code : , After much trail and error, I've found the solution:
If Tasks.Exists("Microsoft Word") Then
AppActivate "Microsoft Word"
Setting RowSource of a Chart in a Microsoft Access 2010 Report
Does that help Reports don't refresh like forms, so if the chart is unbound you'll have to take care and place the code changing the row source in an event which occurs before the report is rendered like the Format or Print event. I'm assuming the IDs you're including in the SQL string are numeric and not strings.