Doug Murphy
dw-murphy at cox.net
Tue May 10 21:34:50 CDT 2005
I don't know about a continuous form, but in a list box there is a selected collection that you could use to delete the selected records. There may be something similar in the continuous form, but I haven't played with it. If your not editing records the list box should provide similar functionality to the continuous form. The other option is to put a delete field in the continuous form and have the user check the records to delete. Then run a delete query using the delete field as the criteria. Not much help but some other approaches. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti Sent: Tuesday, May 10, 2005 6:03 PM To: AccessD at databaseadvisors.com Subject: [AccessD] vba to Delete mult records continous form RESENDING THIS AS IT DIDN'T APPEAR? ---------------------------------------------------------------------------- ---- 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com