In the event procedure for the subform's On Delete event, put code to make the desired changes to the desired fields, and set the Cancel argument to True (to keep the delete action from actually happening). The code to change the fields can either be simple assignment statements (e.g., Field1 = "", Field2 = "", etc.) or you could get fancy and use DAO and a DO loop to cycle through all the fields.
