Access using Microsoft Graph

[LongYP]

I have used the FILTER property on standard Access reports to limit the data displayed from a query. So far.. so good.

However, when using Micrsoft Graph embedded into an Access report I can not work out how to apply the filter to the graph.

Any help would be appreciated.

Many thanks

 

[dhookom]

There are several ways to change the data displayed in the graph control:
-Change the SQL of the RowSource property of the control
-Use the Link Master/Child properties of the control
-Use a criteria in the Row Source property like:
Between Forms!frmA!txtStartDate and Forms!frmA!txtEndDate

You could possibly modify the Row Source to include the Filter property value of the main report.

Duane
MS Access MVP

 

[LongYP]

Many thanks for the response.

I think changing the SQL of the row source will be my best bet. appending a nice 'WHERE' clause on the end.

Sorry to be dumb.

What would the syntax be to reference the Rowsource property of the graph control?

e.g forms!graphcontrol.rowsource?

Thanks

 

[dhookom]

I assume your use of "forms!..." was a slip. In the On Format event of the section contain the graph control, you can use code like:
Me.GraphControl.RowSource = "Select.... WHERE...."

Duane
MS Access MVP