Dynamically changing SQL in Charts

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Does anyone know how to do this?

I've been trying to change the RowSource of the OLE
object without success.

Any help would be greatly appreciated.

Thanks,
Tim
 
You can try set the Row Source to a saved query. Then use code to change the
SQL of the saved query.
Currentdb.QueryDefs("qselMyGraph").SQL = "SELECT ....."
Do you understand that you can use the Link Master Child properties to limit
the displayed data?
 
Duane,

Would I put that code in the Report_Open subroutine?
Then, refresh it or do I change it in code before opening
the report?

Also, do you have an example of using the Link Master
Child properties?

Thanks you for your help!

Tim
 
You could try change the SQL of the saved query in some event code that
coincides when you want to change the Row Source.

The Link Master Child properties work exactly like the same properties on
subform or subreport controls.
 
Back
Top