H
Hector via AccessMonster.com
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).
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).