Graphs: How to update a graph from Combo Box Selection

[jabmod]

I have a graph that plots data for product sales for each month.

I need to update the graph with the data for each month as a selection of month name is made from the combo box

How do I go about getting this to work?

Thanks

 

[dhookom]

A graph displays the results of its Row Source property. The Row Source is generally a query or table or SQL statement. This query can contain a criteria like any other query. You can set the criteria under a month name field in your row source to:

 [Forms]![YourFormNameHere]![YourComboBoxNameHere]

I rarely filter on a month name as I prefer the month number.

Duane
Hook'D on Access
MS Access MVP