on delete event in subform

[suki360]

I am using an Access 2003 mdb front end with SQL Server 2005 backend and have an invoice form with an invoice line item subform. I've written code on the on delete event of the subform so that when an invoice line item is deleted, then I update the inventory table. It works great if one line item is deleted. But if multiple line items are selected and deleted, then Access hangs. I can't seem to run queries in SQL Server either until I kill Access in task manager. The invoice lines don't get deleted.

If I remove all code from the on delete event, then the delete proceeds normally for multiple selections. If I add just a couple of lines of code back to the on delete event (taking out the update to the inventory table), Access hangs again.

Has anyone else experienced this or know what's going on?
Thank you!
Kim

[suki360]

Actually code does work - it's a DAO snapshot recordset that's causing the issue. But I'm still perplexed as to why the code with the recordset will work with single row deletions in the subform, just not multiple row deletions as the code should run for each selected row to be deleted.