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
Best Regards
Virusim