List Box will only find values in my from the 1st Column Only

T

tina

I have a list box in my form with 5 columns. I need to be able to select a
row from my list box and then the form displays the record that matches the
five fields from my list box.
 
C

Carl Rapson

tina said:
I have a list box in my form with 5 columns. I need to be able to select a
row from my list box and then the form displays the record that matches
the
five fields from my list box.
Click to expand...

Refer to the other columns in the list box with the Column collection:

ctlListBox.Column(1) = 2nd column
ctlListBox.Column(2) = 3rd column
etc.

Carl Rapson
 
T

tina

I did this already and I am able to get those to show up in separate text
boxes but they will not find the record on my form that matches my selection.
It only returns records that match the first column. Thanks for your
response.
 
Top