Create another counter and increase that when the condition you want matches

Alex, I appreciate you getting back to me, but I'm more of a visual learner. Any chance I could get some sort of example?

Example from page:
For Counter = Start to End [Step Increment]
    ' Your Code Here
    [If Condition Then Exit For]
Next [Counter]

Untested but hopefully gives you an idea

Dim x

For I = 1 To 10
  If I % 2 = 0
    x = x + 1
  End If
Next I

Thank you Alex. The hard part is I don't know how many records will be affected prior to the loop running. The loop will run through the records in a table changing a value based on a few factors. The loop runs great, but the counter I have setup totals how many records were evaluated. I'm looking for the total number of records the value was changed as a result of the loop. That is a number I don't have prior to the loop running.

A For-Next loop can only be used if you know the lower and upper limits.  If you don't, use the Do-Until loop instead:

Put a counter inside the recordset loop, and increment it by 1 whenever the condition is met.  E.g.:

    Dim r As Recordset, c As Integer
    c = 0
    Set r = CurrentDb.OpenRecordset( ... )
    If r.RecordCount > 0 Then
        r.MoveFirst
        Do Until r.EOF
            If X = Y Then c = c + 1
            r.MoveNext
        Loop
    End If
    MsgBox "Number of records affected: " & c    


P.S. The older Do-While loop can also be used, and it works oppositely to Do-Until:

     Do While Not r.EOF
          ...
     Loop

Perfect! Thank you