Hi !
The intent:
In a form, I have a data entry subform linked to a recordset.
In the same form a have a graph.  I want the graph to be refreshed based on
a query generated by the subform based on the click event of the control in
the subform. In other words, if I click temperature I want the graph to
plot temperature and refresh the temperature as i enter more data in the
subform.  If I enter pressure data I want the graph to plot pressure etc.

The problem:
I have a public variable as string in the main form which I try to update
from the subform click event of the control (for example a text-box that
holds temperature or pressure).