none
loop and capture a column of a combo box on a form RRS feed

  • 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

    Monday, October 19, 2015 2:17 PM

All replies

  • 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

    Monday, May 23, 2016 1:46 AM