This works but .... (Resolved Thanks)

[CliffPhilip]

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?