I have a disconnected recordset which I have bound to a table
<table datasrc="ADC">
I can then add records with a call like this:
ADC.addnew
and delete records with
function del(sText)
intX = Mid(sText,4)
ADC.recordset.Find "id = " & intX
If not ADC.recordset.EOF then
ADC.recordset.delete
end if
end function
The problem is I can't get an id for new records so until I submit I can't
delete new records. I have a temporary solution which will delete the
last new record, but this is a bit kludgie.
Any advise would be appreciated.