Thank you for the suggestion, however it yeilded only partial success. It appears that changes to a variable are not reflected in the control until a form refresh is done.
Side note: initial attemps using the function solution were unsuccessful, there appeared to be residual flags on the control which still caused the #name error to occur, until I deleted the control and created a new one.
I also tried to generalize...
User Profile
Collapse
-
form Control auto updated from global variable
Is it possible to cause a contents of a variable defined in a Module as public, to be retrieved by a control(textbox ) in the trailer of a bound single view Form.
Where desired data is not associated with the Table. bound to the Form
The variable's content is an application calculation.
Environment:
Windows Vista Ultimate, Access 2007
object: Module1
public varname as double
... -
form Control auto updated from global variable
Is it possible to cause a contents of a variable defined in a Module as public, to be retrieved by a control(textbox ) in the trailer of a bound single view Form.
Where desired data is not associated with the Table. bound to the Form
The variable's content is an application calculation.
Environment:
Windows Vista Ultimate, Access 2007
object: Module1
public varname as double
...
No activity results to display
Show More
Leave a comment: