How do I convert the enclosed code from DAO to ADO

[jazzz]

Hello, I am trying to get an understanding on ADO. I have code I created in DAO and would like to see it converted to ADO so I can view what the differences would be and why? Here is the code in DAO

Dim rsClone As DAO.Recordset
Dim lngRecipeID As Long

Set rsClone = Me.RecordsetClone()

'* locate the current record number and store it for future use.
varRecipeID = Me("recipeID&quot

lngRecipeID = varRecipeID

'* turn paining off to eliminate screen flash.
Me.Painting = 0

'* now requery the recordset and get our current location and
'* place the record where it belongs.
With rsClone
.Requery
.FindFirst "RecipeID = " & lngRecipeID

If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With

Me.Refresh Life's a journey enjoy the ride...

jazzz

 

[braindead2]

look at this article from microsoft

http://msdn.microsoft.com/library/d...n-us/dndao/html/daotoadoupdate.asp?frame=true