Unanswered: Deleting Recordsets Using DataEnvironment?
Can someone please shed some light on how to delete recordsets using dataenvironments? I've got a form that has a DataGrid on it as well as (2) DataCombo boxes along with a few text boxes. The project involves adding information to the table with one MDI child form and then updating/deleting records using a different MDI child form.
I'm able to add information to the database (Access) but I'm not able to correctly delete them. I've got code that does delete a recordset, but it doesn't delete the right record - only the first one. I'm assuming I have to utilize the dataenvironment.rsBooks.movefirst or .next or .previous or something like that, but I can't figure out how to set it up. Please help!!