ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MultiPage Form Question (https://www.excelbanter.com/excel-discussion-misc-queries/251935-multipage-form-question.html)

NFL

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!

Rob

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!




NFL

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!



.


Rob

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!



.




NFL

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