M Michael Walsh Feb 20, 2004 #1 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 Feb 20, 2004 #2 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
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