Hi all
I want to know if I can achieve the followings when using an ADO control on the form:

Dim dbSe As Connection
Dim recSet2 As Recordset

Set dbSe = New Connection
dbSe.Provider = "msdasql"
dbSe.ConnectionString = "dsn=Xtreme sample" _
& "data;uid=sa;pwd=;"

dbSe.Open

Set recSet2 = New Recordset
recSet2.Open "select * from customer", dbSe, _
& adOpenDynamic, adLockPessimistic

txtFields.DataField = "Customer ID"
Set txtFields.DataSource = adoPrimaryRS

I got a ADO control on the form called 'adoRecset' which refers to a DSN and then for its recordset to a table call 'customer'.