How can I reference fields of a subform placed on a main form. I have a subform that loads with a Mainform that is pulling data based on a parameter of "TS" and "VAP" for type. I have the user adding records to subform called ProductsInvoiceRec. I have set the prperties of this subform to load on the mainform and automatically go to the next record on the form load event. I also need two other subforms that are loaded based on a parameter of "TS" and "VAP" . These subforms are taking the records which are TS and Vap and making Subtotals. I need for these two forms to clear out. In other words, I outneed all of the fields on these two subforms to clear out and make spaceseverytime a new record is added on the ProductsInvoiceRec on the Inoice Main form.
ow can I reference the invidual fields of a subform on the Load, AfterUpdate, and Before Update events in the properties of these two forms using the form preoprties?
I can't use a datasheet for this project.