I am trying to scroll through an ADO Recordset (sorted by email) and find any email address that is the same as the email address of the next record. I'm using VBA - MS Access 2000
Do Until rstDupEmail.EOF
If rstDupEmail.fields("Email")= **The email address of the next record** then
How do i find "The Email address of the next record"?