form Control auto updated from global variable

[superspie]

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

object: myform
Trailer section
textbox: display

failed attempt using :

textbox: Display
control source of: =Module1.varnam e

I realize I could programatically do this off some Event, I just looking for another way

[debasisdas]

Hi superspie

Welcome to TSDN.

Feel free to post questions in the related forum only by choosing from under the blue bar on the top of your page.

Please follow the posting guidelines in every new post/reply.

Please specify your post/question clearly.Please use proper code tags in all your codes.

Regards
Debasis