Let's say I have a form, with a subform in it. From within the main form module, can I force a save of the record(s) in the subform? For example, let's say the save button for the subform isn't in the subform, but in the main form. I know I could place a Sub or a Function within the sub-forms module (DoCmd.RunCommand acCmdSaveRecord) and call it from within the main module, but is there a better method?
I don't know of any method of doing a save record on a record in the sub form from the main form, except, as you said, putting the actual function in the subform and calling that from the main form. I also don't see any reason to not use this method.