loop and capture a column of a combo box on a form

Question

i have combo box on a form and I am trying to do two things, first see if there are items in the combo box and the second is to loop through all of the items a capture the value in column (1): the following works great and is all I am trying to do, accept I want to show all the lines (if any) that show on the form: 

Debug.Print Forms!frm_video!SFrm_ShotBy!E_ID.Column(1)

Thank you in advance.   Chris B.

---

chris beardsley

Answer 1

Hi Chris,

A combo box can normally only hod a single value! Yes you can read the data from the other columns in the rowsource but are still limited to the selected row.

Perhaps you neet to use a multiselect list box?

---

Brian, ProcessIT- Hawke`s Bay, New Zealand