This works but .... (Resolved Thanks)

Back the the ADODB recordset..Thanks to those who advised me to add the adLockOptimistic so I could actually add records to the record set and subsequently the table. The following code work just fine.

sqlTest = "Select * from test"
rstTest.Open sqlTest, strFile, adOpenDynamic, adLockOptimistic
rstTest.AddNew
For n = 0 To 7
rstTest(n) = Me.txtTest(n).Text
Next n
rstTest.Update

However, the following does not work...

rstTest(4) = me.txtTest(4).text
rstTest.Update

Do I need to put the recordset into some sort of "edit" mode before trying to update it?

CliffPhilip,

I do not use this kind of editing often (I use SQL), but when I did I opened the recordset using:


adLockPessimistic