Bound text box in a chart tied to parameter field in a query

  • Thread starter Thread starter Russ
  • Start date Start date
R

Russ

I am using MS Access 2002. I need to set up a bound text
box, within a chart that is imbedded within a report,
which is bound to a parameter field, in a query that the
chart is based upon. I need to represent, in a bound text
box, the parameter values to extrapolate specific data,
from the query. I have created a manual process, which I
desire to automate, since the manual process of changing
the wording, in the text box, takes too long and
introduces a higher probability, of error. Any assistance
would be most appreciated. Thank you.

Russ
 
I am using MS Access 2002. I need to set up a bound text
box, within a chart that is imbedded within a report,
which is bound to a parameter field, in a query that the
chart is based upon. I need to represent, in a bound text
box, the parameter values to extrapolate specific data,
from the query. I have created a manual process, which I
desire to automate, since the manual process of changing
the wording, in the text box, takes too long and
introduces a higher probability, of error. Any assistance
would be most appreciated. Thank you.

Russ
Click to expand...

Are you trying to have a chart label show something like this?
"Sales for May 2003"
With the date changing according to the query parameters?
If a form is used to enter the parameter...
Code the Report section's Format event that the chart is placed in:

Me!OLEUnbound0.ChartTitle.Text = "Sales for " &
Format(Forms!frmDate!StartDate, "mmmm yyyy")
Me!OleUnbound0.Refresh

If just the query parameter prompt is used:

Me!OLEUnbound0.ChartTitle.Text = "Sales for " & [Enter Date]
Me!OLEUnbound0.Refresh

Change OLEUnbound0 to whatever the control name is of your chart
control.

Alternatively, you could simply place a label over an unused portion
of the chart:
LabelName.Caption = "Sales For " & [Enter Date]

[Enter Date] being the query parameter prompt.
 
Back
Top