I want to use a For Each...Next statement, but these can only be used on Arrays or Collections.
Everything I have tried so far is not looping as I am expecting, or filtering down and returning the correct results. So I am trying a different approach.
Says who?
What is wrong with
Do while
Loop
and loop thru a table??
Dim Cupidrst as DAO.Recordset
Dim strSql1 as String
Dim strCupid as Variant
strSql1 = "SELECT DISTINCT Cupid FROM table etc"
Set Cupidrst = CurrentDb.OpenRecordset(strSql1, dbOpensnapshopt, dbReadOnly)
do while not cupidrst.eof
strCupid = [Cupidrst]![Cupid]
' more code
cupidrst.movenext
loop
LOLNamliam, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou.
What is your problem with your filtering?Now I just need to resolve the (SQL) filtering.
What is not?? LOLAha - that's another thing that's not explicitly explained on the MSDN site