Re: Two Subforms on a Form
Hi there,
I have a form [StudentDetails] and two subforms [FeesDetails] and [PayersDetails].
I have a Relationship for the main form [StudentDetails] and [FeesDetails]subform, whereby when the Student_ID is the same the FeesDetails text fields are populated on the subform.
I also have an insert button whcih when you click it, it takes you to another Form [FeesDetails1] which is built up of a combo box. The drop down of the combo box has the
Payer_code, Name, and Address.
I want to be able to click a Payer_code (for example TY7634) and this data is populated in the subform [FeesDetails] and at the same time populate the Name and Address to the [PayersDetails] Subform.
Need your help!!!
Thanking you in advance
jamil
Hi there,
I have a form [StudentDetails] and two subforms [FeesDetails] and [PayersDetails].
I have a Relationship for the main form [StudentDetails] and [FeesDetails]subform, whereby when the Student_ID is the same the FeesDetails text fields are populated on the subform.
I also have an insert button whcih when you click it, it takes you to another Form [FeesDetails1] which is built up of a combo box. The drop down of the combo box has the
Payer_code, Name, and Address.
I want to be able to click a Payer_code (for example TY7634) and this data is populated in the subform [FeesDetails] and at the same time populate the Name and Address to the [PayersDetails] Subform.
Need your help!!!
Thanking you in advance
jamil
