Hi,

I am using VB6 with ADO 2.6 and datagrid control without ADO control.
Whenever, I delete the first record, the datagrid
update and display my record correctly, however,
on the second delete, it display that deleted
records columns as #Error

My code is shown below


rs.Open "outlet1.dbf", cn, adOpenKeySet, adLockOptimistic, adCmdTable

set datagrid.datasource = rs

rs.delete <-------- work fine, display is okay in the datagrid
rs.update
datagrid.ClearFields
datagrid.Rebind

rs.delete <-------- Display #Error for that individual row in their columns.
rs.update
datagrid.ClearFields
datagrid.Rebind

Please assist and advise. Thank you