list box question - URGENT

[ghostmachine]

Hello everyone,

I seem to be losing my mind. I have a data access page that has a list box
on it. The list box has two columns attached to it. They are companyname and
password.
Password is the listdisplayfield and companyname is the listboundfield. When
the user selects the company name from an above field the listbox moves to
the correct password in the listbox. I then need to take that password that
is being displayed and compare it to the value they entered. HOW CAN I GET
THE LISTDISPLAYFIELDS VALUE. Please help

Thank you in advance for your time and assistance

 

[Ofer]

To get the password value that is in the second column you need to wrie
Me.ListBoxName.Column(1)

The numbers starts with 0

 

[ghostmachine]

I forgot to mention that I am working in a Data Access Page