Access automatically saves the records in a form when you move to another record or when you leave the form either by closing it or moving the focus to another form (like in leaving the subform by clicking on the main form); this applies to the subform's records too. So what exactly are you trying to achieve? Do you have any kind of validation that needs to happen at the subform record level (individual record)? Implement that in the (sub)form's BeforeUpdate event and remove the reference to the cmdSave button cause you don't have one. If you leave the Save button on the form the subform record gets saved by the time you click Save because the focus left the subform so it saves the record.



Cheers,