>Hi all,
>
>I was trying to add a new record in a empty (no records) recordset and as soon as I write something in a cell, I get -7008 Error: "The current row is not available". This doesn't happen in a DataGrid with records.
>
>
>Any ideas about how to solve this, will be very useful....
>
>Thanks a lot,
>
>glurrea

hi,

Try this....

dim rs as adodb.recordset
Set RS = New ADODB.Recordset
RS.CursorLocation = adUseClient
RS.CursorType = adOpenDynamic
RS.Open "SELECT * FROM table_name", connection_string, adOpenDynamic, adLockOptimistic