I would say it depends on what you're trying to accomplish (ie what are you doing with the selected items?). If it's to filter a query, selecting all is the same as not including that field in the criteria at all. You can do this type of loop to either act on the items directly or select/deselect all:
Code:
For i = 0 To Me.ListBoxName.ListCount - 1
Me.ListBoxName.Selected(i) = True
Next i
I'm not clear on what you mean by "run the results of a select statement through a FOR loop". From the sound of it, you'd open a recordset on the SQL and then run a
Do While Not rs.EOF
loop on it which would access every record returned.