Dynamicly updating a chart title with parameter from a query

  • Thread starter Thread starter Kevin
  • Start date Start date
Using VB, how do I update the title on a chart with the
parameter from a parameter query?
Click to expand...

Whatever section of the report the chart is in, code that section's
Format event:

Me!OLEUnbound7.ChartTitle.Text = "Sales from " &
Forms!frmDate!StartDate
Me!OLEUnbound7.Requery

Change OLEUnbound7 to the name of the chart control, and of course use
your own text.

Forms!frmDate!StartDate is the parameter that the query uses to get
the value from a form.

If you are using a parameter prompt in the query (i.e. [Enter Start
Date], then use that in the code.
 
Thanks. I'll try it.
-----Original Message-----
Using VB, how do I update the title on a chart with the
parameter from a parameter query?
Click to expand...

Whatever section of the report the chart is in, code that section's
Format event:

Me!OLEUnbound7.ChartTitle.Text = "Sales from " &
Forms!frmDate!StartDate
Me!OLEUnbound7.Requery

Change OLEUnbound7 to the name of the chart control, and of course use
your own text.

Forms!frmDate!StartDate is the parameter that the query uses to get
the value from a form.

If you are using a parameter prompt in the query (i.e. [Enter Start
Date], then use that in the code.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top