![]() |
MultiPage Form Question
How do I pass values from one textbox from the 1st tab to the 2nd tab? For
example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab of the multipage form, me.textbox2 is empty. I tried this the code below and it didn't work. me.textbox2.value = me.textbox1.value Thank you! |
MultiPage Form Question
Hi,
The below code added to TextBox1 does reflect changes made and shows in TextBox2 HTHs Rob Sub TextBox1_Change() Me.TextBox2.Value = Me.TextBox1.Value End Sub "NFL" wrote in message ... How do I pass values from one textbox from the 1st tab to the 2nd tab? For example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab of the multipage form, me.textbox2 is empty. I tried this the code below and it didn't work. me.textbox2.value = me.textbox1.value Thank you! |
MultiPage Form Question
You're right... it does work. The value will only appear when a keystroke
is made on that field. Is there a way to have the value appear without placing a cursor and typing a keystroke? "Rob" wrote: Hi, The below code added to TextBox1 does reflect changes made and shows in TextBox2 HTHs Rob Sub TextBox1_Change() Me.TextBox2.Value = Me.TextBox1.Value End Sub "NFL" wrote in message ... How do I pass values from one textbox from the 1st tab to the 2nd tab? For example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab of the multipage form, me.textbox2 is empty. I tried this the code below and it didn't work. me.textbox2.value = me.textbox1.value Thank you! . |
MultiPage Form Question
You'll need an event triggered to run code to transfer the contents from one
textbox to another, there are a few options including when the form shows. HTHs, Rob "NFL" wrote in message ... You're right... it does work. The value will only appear when a keystroke is made on that field. Is there a way to have the value appear without placing a cursor and typing a keystroke? "Rob" wrote: Hi, The below code added to TextBox1 does reflect changes made and shows in TextBox2 HTHs Rob Sub TextBox1_Change() Me.TextBox2.Value = Me.TextBox1.Value End Sub "NFL" wrote in message ... How do I pass values from one textbox from the 1st tab to the 2nd tab? For example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab of the multipage form, me.textbox2 is empty. I tried this the code below and it didn't work. me.textbox2.value = me.textbox1.value Thank you! . |
MultiPage Form Question
I'm not sure how to do this. Can you show me how to do this and where would
the code be placed? "Rob" wrote: You'll need an event triggered to run code to transfer the contents from one textbox to another, there are a few options including when the form shows. HTHs, Rob "NFL" wrote in message ... You're right... it does work. The value will only appear when a keystroke is made on that field. Is there a way to have the value appear without placing a cursor and typing a keystroke? "Rob" wrote: Hi, The below code added to TextBox1 does reflect changes made and shows in TextBox2 HTHs Rob Sub TextBox1_Change() Me.TextBox2.Value = Me.TextBox1.Value End Sub "NFL" wrote in message ... How do I pass values from one textbox from the 1st tab to the 2nd tab? For example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab of the multipage form, me.textbox2 is empty. I tried this the code below and it didn't work. me.textbox2.value = me.textbox1.value Thank you! . . |
All times are GMT +1. The time now is 04:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com