Hi! Does anyone know if it is possible to access the unbound column in a list box? Here is what I am trying to do:
I have a list box that has two columns,
1 - Name (unbound but visible)
2 - E-mail address (bound but not visible)
When the user double-clicks on the name in the list box, the e-mail address (the bound column) is pasted into a field on another form. What I would like, is the name (the unbound column) to be pasted into another field on the other form. These fields on the other form are memo fields that serve as lists. Essentially, I want to end up with two lists on the other form, one of e-mail addresses and one of their corresponding names. The list of e-mail addresses will be used to invoke an e-mail but the list of names is what the user will see. Any ideas?
I have a list box that has two columns,
1 - Name (unbound but visible)
2 - E-mail address (bound but not visible)
When the user double-clicks on the name in the list box, the e-mail address (the bound column) is pasted into a field on another form. What I would like, is the name (the unbound column) to be pasted into another field on the other form. These fields on the other form are memo fields that serve as lists. Essentially, I want to end up with two lists on the other form, one of e-mail addresses and one of their corresponding names. The list of e-mail addresses will be used to invoke an e-mail but the list of names is what the user will see. Any ideas?
