Displaying fields from listbox to textboxes

[OrganMan]

Can someone help me out?

I have a listbox that is populated with data from a recordset. I would like to know how to display the data on a record in the listbox when clicked into the corresponding textboxes on the botom of the form.

I have the following textboxes on the bottom txtCardNo, txtFirstName and txtLastName. I also have another textbox on the bottom for quantity and a combobox for condition. I should be able to enter the quantity of a particular that I own and the condition of the card. Example I own 3 Wayne Gretzky cards 2 in Mint condition and one in excellent condition.

I need help on which event to use for when I click on the card in the listbox and it fills in the three textboxes on the bottom of the form, also whether or not I will need to create another recordset.

Thanks for all the help

 

[Villarreal68]

What I would do is the following:
Just to confirm the textboxes are "unbound" correct?
If they are, then in the textbox enter the following code:
=[ListBoxName].[Column](#)
Make sure to replace the # with the Column Number in the List Box that has the data you want.