Click to See Complete Forum and Search --> : TextBoxes


January 18th, 2000, 07:16 AM
Hi Guys,
I want to change the contents in .....say five text boxes depending on the Employeename i type in the first textbox.
Eg: I have 6 textboxes and when i type the name of the employee in the first textbox then the rest of the five textboxes should automatically have all his information as i type. I know you guys could help me out on this one. Thanks in advance,
Derek

January 18th, 2000, 02:35 PM
in the text1_change protocol, enter the following code:

private Sub Text1_change
'I assume the names of the textboxes are text2, text3, text4, etc...
text2.text = text1.text
text3.text = text1.text
text4.text = text1.text
text5.text = text1.text
text6.text = text1.text
'If you don't want their text to be overwritten, meaning it is added on, enter the following code:
text2.text = text2.text & text1.text
text3.text = text3.text & text1.text
.
.
.
text6.text=text6.text & text1.text

coolily
January 20th, 2000, 10:13 PM
is this what u wanted to know?

Starcraft
January 20th, 2000, 11:24 PM
Private Sub Text1_Change()
Text2 = Text1
Text3 = Text1
Text4 = Text1
Text5 = Text1
End Sub