Populate Label Based on listbox

[junimation]

I have a list box that is populated based on a table. now I have three labes that are also added to the form. What I will like to do is....

ListBox (3 colums)
On Double Click (listbox)
Set Label1 to the First Column.text in the list box
Set Label2 to the Second Column.text in the list box
Set Label3 to the Third Column.text in the list box


What i'm looking for is a way to update my labes based on the selection I make in the list box.
kind of like a confirmation.

On Double click it will show on label and it will act as a confirmation.
This customer(record) has been selected!

If there is another way to kind of show this same functionality please tell. I'm kind of new at Access but a master in Excel so I'm not affraid of VBA.


Thank you in advance.

 

[WayneRyan]

j,

Use the double-click event:

Me.Label1.Caption = Me.YourListBox.Column(0)
Me.Label2.Caption = Me.YourListBox.Column(1)
Me.Label3.Caption = Me.YourListBox.Column(2)

Wayne

 

[junimation]

That was it? I tried that before it did not work. I guess I was doing something wrong.
I will try it again to see what I did wrong. Thank you very much for your Response.