mlcktmguy
asked on
Obtaining SubForm Information from Main From
I have a standard Mainform 'frmInstallPayHdr', subform 'frmInstallPaySub' form. They are both bound forms 'tblInstallPayHdr' and 'tblInstal;lPaySub' respectively..
The link between the Main and Subform is InstallPayHdrID which is the unique autonumber primary key assigned to each InstallPlan.
From within 'frmInstallPayHdr' I would like to get a list of all the elements in 'frmInstallPaySub'.
My plan is to pull the list using ADO with a select string something like 'Select * from tblInstallPaySub Where InstallPayHdrID (in sub table) = InstallpayHdrID (in main table) and a loop to read all the returned records.
Is there a better/easier way to get the list of elements in the subform?
The link between the Main and Subform is InstallPayHdrID which is the unique autonumber primary key assigned to each InstallPlan.
From within 'frmInstallPayHdr' I would like to get a list of all the elements in 'frmInstallPaySub'.
My plan is to pull the list using ADO with a select string something like 'Select * from tblInstallPaySub Where InstallPayHdrID (in sub table) = InstallpayHdrID (in main table) and a loop to read all the returned records.
Is there a better/easier way to get the list of elements in the subform?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER