Carry variable from vba module to form

M

Michael Walsh

How can I set a value unrelated to any table or form in a
vba module and then use it in a form?
 
D

Dan Artuso

Hi,
If it's a public variable in a standard module, then you can read/change the
value from anywhere in your code simply by refering to the variable.
If you wanted to display the value in a textbox:

Me.yourTextBox = yourPublicVar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top