Kath Pelletti
KP at sdsonline.net
Wed May 11 21:05:50 CDT 2005
Brilliant - it took me little while to play with it and get it to work for subforms but that is exactly the solution, Thanks David - and thanks Darren for help, Kath ----- Original Message ----- From: David Beckles To: accessd at databaseadvisors.com Sent: Wednesday, May 11, 2005 7:40 PM Subject: [AccessD] RE: vba to Delete mult records continous form Dear Kath, I think that your problem is solved in the KB article " How to enumerate selected form records in Access 2002" at http://support.microsoft.com/?kbid=294202 The article also contains references to the Access 97 and Access 2000 versions of the solution. I hope that this helps. David Beckles --------Original Message------------------ Message: 7 Date: Wed, 11 May 2005 10:49:09 +1000 From: "Kath Pelletti" <KP at sdsonline.net> Subject: [AccessD] vba to Delete mult records continous form To: <AccessD at databaseadvisors.com> Message-ID: <001301c555c3$3ea3e800$6401a8c0 at user> Content-Type: text/plain; charset="iso-8859-1" Hi everyone - maybe I am just having a bad day but can someone tell me the code I need in vba to do the same action as the [Records] [Delete] menu? ie. I have a continuous form, user selects a block of records to delete. If I use DoCmd.RunCommand acCmdDeleteRecord then it only takes out the first rec. How can I get rid of them all? I could do it with a delete sql string if I knew how to reference the selected records. TIA Kath ______________________________________________ Kath Pelletti Software Design & Solutions Pty Ltd. ------------------------------ -- David Beckles -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com