There is a list box that has both an ID number as well as a facility name inside it. I want to truncate the string to just the ID number AFTER the user selects it from the list (user doesn't know the facilities by number so they need to see the name). Is there a different event I could do this under?
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is there an AfterUpdate event on a cell in excel?
- Thread starter Paladyr
- Start date
Databaseguy
MIS
If your list box is on a form, you can get to the data in the columns like this:
ListBox1.Column(2)' This is the 2nd column in the selected choice Tyrone Lumley
augerinn@gte.net
ListBox1.Column(2)' This is the 2nd column in the selected choice Tyrone Lumley
augerinn@gte.net
- Thread starter
- #3
. I figured out a work around though - Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question