It certainly can be done. The easiest way is to click on the relationships button in the toolbar, double click on the link between the main table and the table from which the sub-form records are drawn, Select "Cascade Delete Related Records" and then OK. Now create a delete record button on the main form in the usual way.
Guy -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of oztitanic101 Sent: Monday, 17 October 2005 9:46 AM To: ms_access@yahoogroups.com Subject: [ms_access] subform Question Hi All I am trying to setup a command button that delete a record and all its subform records can it be done? has anyone done it? it so how? Andrew ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
