Ive got a form which collects 4 variables from the user to feed to a query which then provides the data for a graph.
Ideally I would like to include the graph on the form along with the data. Unfortunately when I do this the graph opens with no data when the form is opened and I cannot find a method to redraw the graph when the fields are filled in by the user. To get it to work I've separated the graph from the form. This means I must close the graph before every update.
Is there any way I can redraw the graph from the form. I included a button which requeried but this only opened the query table and did nothing to the graph?
Looking forward to your help.
Ideally I would like to include the graph on the form along with the data. Unfortunately when I do this the graph opens with no data when the form is opened and I cannot find a method to redraw the graph when the fields are filled in by the user. To get it to work I've separated the graph from the form. This means I must close the graph before every update.
Is there any way I can redraw the graph from the form. I included a button which requeried but this only opened the query table and did nothing to the graph?
Looking forward to your help.
