updating a field on a form

[George]

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?

[pbaldy]

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

[George]

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

[pbaldy]

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.

[George]

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?

[pbaldy]

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.

[George]

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.

[pbaldy]

What's the code? The only way the change event works is with the .Text property.