In my form I use a combo box to pick a staff name from a list. The data source for the combo box, also has the staff phone number listed (2 columns in SQL, 'Name' & 'Phone').<br><br>Is there anyway to have the phone number entered in the 'phone' field when user picks a name from the combo box for the 'name' field?<br><br>Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combo box question 1
- Thread starter shar
- Start date
-
1
- #2
Sure, use . . .<br><br>' for clarity<br>Const NameIndex = 0<br>Const PhoneIndex = 1<br><br>Private Sub Combo1_DblClick<br> Form![textfieldA] = Combo1.Column(PhoneIndex)<br> Form![textfieldB] = Combo1.Column(NameIndex)<br>End sub<br><br><br>Enjoy !<br> <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
