Good day All,
Textbox9 = Textbox8 * 2 on a form
When a value is entered into Textbox8 the change is not updated in Textbox9. ,
How can I get Textbox9 to automatically show the change when a value is entered into Textbox8?
Good day All,
Textbox9 = Textbox8 * 2 on a form
When a value is entered into Textbox8 the change is not updated in Textbox9. ,
How can I get Textbox9 to automatically show the change when a value is entered into Textbox8?
If you're doing that in code, you'd have to do it in the after update event of Textbox8. You could also just make the control source of Textbox9:
= Textbox8 * 2
Thank Paul; that works fine. However I want TextBox8 = Panel, which is a variable in another module on the same form. I tried passing the variable through the parameter section of the afterUpdate event but that triggers an error.
I there a way for this to be done?
George
If you want the variable available to multiple procedures in the same form, declare it at the top of the module before the first procedure.
Thanks again Paul. That works fine also.
Now another related challenge: How can I get TextBox9 to update in realtime as I enter values in TextBox8 one by one?
To do that you'd use the change event rather than the after update event. You'd also have to use the .Text property of 8.
Thanks. Once again this has worked perfectly well; however I didn't use the text property of 8; in fact I don't understand it.
What's the code? The only way the change event works is with the .Text property.