多谢楼上两位!具体代码如下:
Do While Not Rs2.EOF
temp2 = Trim(Rs2(0))
If temp1 = temp2 Then
Rs2(1) = li_kk
temp1 = temp2
Else
Rs2(1) = li_kk
temp1 = temp2
li_kk = li_kk + 1
End If
If Not Rs2.EOF Then
Rs2.MoveNext
End If
Loop
问题是:更新最后一条记录时出现错误,但是最后一条记录也更新了,我跟踪调试发现是,最后MoveNext的时候出现错误!