jjc9809
asked on
Access 2007 Subforms of a Main Form question
Hi ever
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.
jjc9809
TradeShow1.accdb
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.
jjc9809
TradeShow1.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.