J
justme0010
In VBA, I have a function that updates the underlying query with a new
date range and product when a button is pressed. This function also
updates the title of the chart. This works, except when the function
executes after the graph happens to have no data in it. It then does
not recognize the graph as even having a title property.
Even when the graph is refreshed WITH data, and the change title code
is the last line AFTER the requerying code, the title is still not
recognized and won't change. It takes a SECOND requerying with an
another set of data for the title to be changed. That doesn't make
sense to me but that's how it works. Is there anything I can do to deal
with this or should I forget about changing the chart title?
date range and product when a button is pressed. This function also
updates the title of the chart. This works, except when the function
executes after the graph happens to have no data in it. It then does
not recognize the graph as even having a title property.
Even when the graph is refreshed WITH data, and the change title code
is the last line AFTER the requerying code, the title is still not
recognized and won't change. It takes a SECOND requerying with an
another set of data for the title to be changed. That doesn't make
sense to me but that's how it works. Is there anything I can do to deal
with this or should I forget about changing the chart title?