David Beckles
becklesd at tiscali.co.uk
Wed May 11 04:40:37 CDT 2005
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