Graphs (Charts?), Forms and Real Time Updates

[pdupreez]

I would like to have a form with a combo box, indicating the field names in a table. After the user selects a field a graph (defined in an unbound object frame) must be displayed using two fields, of which the selected one from the combo box , is the y-axis data. I can however not seem to update the rowsource for the graph, or rather, I can update the rowsource, but the graph does not reflect the changes, how do you programmatically change the graph data, or field source?

 

[markphsd]

Just keep working on it. I do what you want to do.

I seem to remember that you can choose to have the chart be linked to data on the form. What you will need to do is first set up the combo boxes, then do the chart. Before you build the chart you might want to try a subform that is filterd by the combo boxes-set it to data sheet view so it mimics the data display that will be on the chait, just to make sure you are getting the right response from your combo box.

 

[pdupreez]

I have worked out a solution. By making my datasource for the graph a Table/Query, and creating the query (in VBA) everytime after I have selected a field, I can update the graph at will. I use 4 combo boxes (for 4 data fields) and is able to select alternative axis etc as required.