V
Vaughan
I guess this is easy to do, but I'm struggling here.
I have created a list box on my form to allow me to select from a list of
Customer Names. The list is a multi-column array, and I want to populate
other fields on the form with the corresponding data in the other columns
(Account number, Territory etc) for the customer selected.
I tried using the Column property as the value in another field, but a get a
wierd result: I.e. setting Value to ListBox1.Column(2) should return the
Account Number, but results in a date like 5 February 2005.
How should I really be doing this?
TIA
I have created a list box on my form to allow me to select from a list of
Customer Names. The list is a multi-column array, and I want to populate
other fields on the form with the corresponding data in the other columns
(Account number, Territory etc) for the customer selected.
I tried using the Column property as the value in another field, but a get a
wierd result: I.e. setting Value to ListBox1.Column(2) should return the
Account Number, but results in a date like 5 February 2005.
How should I really be doing this?
TIA