Command, On Click, Save Form and Sub-form possible?

[TDC21]

I have two tables, Order and Order_Line, a one to many relationship exists and I created a form with a sub-form. I added a on click save command but it looks like the command is only associated with the Order table though. On click the order table is updated with the new entries but none of the Order_Line entries are carried over. Can the command be altered to save both the Form and the Sub_Form on click? If so, how?

Thanks everyone, any suggestions are appreciated as always

 

[Micron]

Whatever you're doing for the main form should work if you know and use the correct subform reference
Forms("MainFormName").Controls("subformControlName").Form.Requery
NOTE: subformControlName IS NOT THE SUBFORM NAME - it is the control that contains the subform

You might be working with the .Dirty property as opposed to the Requery method - you don't say.

There's another syntax that I use for referencing subform controls instead of properties:
[Forms]![Main form name]![subform control name].[Form]![control name on subform]

For some reason, I never got that syntax to work when accessing subform properties or methods (like RecordCount or Requery), so I use the former. If you care to give it a try, it would probably be
[Forms]![Main form name]![subform control name].[Form].Requery or
[Forms]![Main form name]![subform control name].[Form]!Requery

Something tells me those won't work.

 

[TDC21]

Thanks Micron

 

[Micron]

You're welcome.
We/I would be interested to know which, if either, syntax worked.
Thanks.