If I have the following:
Code:
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT ID, assigned FROM tbl142", dbOpenDynaset)
How do I reference that to make a for each loop?