Refer to second column in listbox

[Chew407]

Good morning,

I have a listbox on a form that when double clicked, puts the value of the bound column of that particular record into a textbox. What I want to know is how, or is it even possible to put the value of the second column into another textbox?

For example...

Me.txtName.Value = Me.EmployeeList.Value
Me.txtDepartment.Value = Me.EmployeeList.Column?2?.Value

I could probably make a second list box and refer to it's unique name (Me.EmployeeDepartment) but I's still like to know if this is possible. Any help you can offer is much appreciated.

Chew

 

[CosmoKramer]

Chew,

The Column property is zero-relative, so try this to get column 2:

Me.txtDepartment.Value = Me.EmployeeList.Column(1).Value

Si hoc legere scis, nimis eruditionis habes

 

[Chew407]

Thanks a lot Kramer.

Me.txtDepartment.Value = Me.EmployeeList.Column(1).Value
produces a run-time error - object required. I took the value off the end and it worked fine. Thanks so much.

How's the coffee table book coming along?

Regards,

Chew

 

[CosmoKramer]

Not as good as Movie Phone.....

Si hoc legere scis, nimis eruditionis habes