ADODB Recordset - using ActiveX Data Object in Access 2007

[john john mackey]

Hi. I wrote some VBA underlying code for an Access 2000 application and used to create/open recordsets in the following manner:

Dim rstLookupFixedAreas As New ADODB.Recordset
rstLookupFixedAreas.Open "tbl\_FixedAreas", CurrentProject.Connection, adOpenStatic, adLockOptimistic

rstLookupFixedAreas.MoveFirst
Do Until (rstLookupFixedAreas.EOF)
    strValueList = strValueList & CStr(rstLookupFixedAreas.Fields(0)) & ";" & rstLookupFixedAreas.Fields(1) & ";"
    rstLookupFixedAreas.MoveNext
Loop

comboFixedArea.RowSource = strValueList
'comboFixedArea.DefaultValue = 1

rstLookupFixedAreas.Close

I did this by including the reference to Microsoft ActiveX Data Object 2.1 Library. Now that I am using Access 2007, is there a more current method to do the same type of "recordset" operations? (or should i continue with including ADO 2.1 Library) I want to use either a record index or Find method to get my record pointer. Thank you for the help. John John