Hi
I have a form which is based on a query. This form contains a sub form which is based on another query linked by a common field ContactID.
1) I can ensure that the main form data is saved by using "dirty" but does this affect the sub form? How do I address the subform directly so that I can ensure that the data is saved.
2) This leads on to another query about sub forms. When saving the whole form I want to add some hidden information to fields in the subform query. How do I address the fields in the query on the record that the subform is using?
Regards
Alan
I have a form which is based on a query. This form contains a sub form which is based on another query linked by a common field ContactID.
1) I can ensure that the main form data is saved by using "dirty" but does this affect the sub form? How do I address the subform directly so that I can ensure that the data is saved.
2) This leads on to another query about sub forms. When saving the whole form I want to add some hidden information to fields in the subform query. How do I address the fields in the query on the record that the subform is using?
Regards
Alan