HOW DO I EDIT A RECORD SET IN ADO

PREVIOUSLY, IN DAO I USED CODE SIMILAR TO THIS:

With rst
            .Edit
                ![Pro Work] = "Yes"
                ![Work Date] = Date
                ![Status] = "App Not in Work Que"
            .Update
End with

How do I edit the same record set using ADO?  I have read a few manuals,
but 
found them a little confusing.  My time limits my search on the internet.

I have my connection established and I am able to read data in from my 
record set
but when my program decisions through the logic it doesn't edit the record

set.