Updating a Graph Using a Command Button

[sjg0003]

I have a number of sql statments that capture the data I want to place in a chart. What I do not know how to do is to be able to update the chart on the fly by using a command button. I currently do not have a chart on my form because I don't know the best method to do this.


Anyone know how to achieve this?

 

[MaxEd]

Have you tried a requery or refresh?

 

[sjg0003]

I do not even know where to begin with the graph. I can manually add a graph but I need to be able to change the information on the fly and not sure how to do this.

 

[MaxEd]

Try attaching a data source to the graph. I have done graphs before but it was rather complicated.