List Box

[Neo]

I have a form that has a list box on it. The list box has two columns
User ID and Password and is called ListID

On another form I have to fields (frm Password)

txtID
txtPassword

I want to be able to double click on the record in the list box and the data is place into txtID and txtPassword

I am using
On_Click

Dim frm As Form
Set frm = Forms![frm Password]
frm!txtUserID = Me.listPasswords
frm!txtPassword= Me.listPassowrds

But it puts the same data into both fields (the first column)
how do I make txtPassword = the second Column

Thanks

 

[Mile-O]

frm!txtUserID = Me.listPasswords.Column(0)
frm!txtPassword= Me.listPasswords.Column(1)