hey,

i've been asking for help regarding the creation of a report from an SQL from a form, the steps i've gotten are used for ADO: myreport.datasource(). so i'm thinking about converting my DAO connection to ADO. i'm not using any data-controls, everything's in code. i was wondering, what DAO-specific lines must i alter? these are some of what i think are DAO codes in my program:

Set DB = OpenDatabase(App.Path & "\Members97.mdb")

Private DB As Database
Private RS As Recordset

Set RS = DB.OpenRecordset()

With RS
.Edit
.Fields("MemSName").Value = txtMemSName.Text
.Update
.Close
End With

anything else i should convert? how about the "project-references" properties?
do i need to put something like: ADODB.conection as a general declaration? also, are SQL statements the same in ADO?