I have moved a list of employees into a List Box that I would like to create a report on. The list box contains three fields. zLName, zFName & zBadgeid. I don't know how to code my query so that it will reference the list box and be able to point it to the correct field. I've tried List2(Column(0) and List2.Column1 but these have not worked. Also do I need to develop a looping routine to go through all the people in my list box so that the query won't just select the first person it finds in the list?
Shan
Shan