Thank it worked and who said you can not teach an old dog--- oldmen a new trick :):) andrew --- In ms_access@yahoogroups.com, "Guy Harley" <[EMAIL PROTECTED]> wrote: > > 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 >
------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/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/