Link to home
Start Free TrialLog in
Avatar of cdmac2
cdmac2

asked on

find next record scrolling through ADO

Hello,

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

                    rstDupEmail.MoveFirst
                    Do Until rstDupEmail.EOF
                        If rstDupEmail.fields("Email")=  **The email address of the next record** then
                            rstDupEmail.Delete
                        End If
                        rstDupEmail.MoveNext
                    Loop

How do i find "The Email address of the next record"?

Thanks,
cdmac
ASKER CERTIFIED SOLUTION
Avatar of Raynard7
Raynard7

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cdmac2
cdmac2

ASKER

Of course... I knew I was overlooking something simple... thanks!
no worries - glad to help