Link to home
Start Free TrialLog in
Avatar of mlcktmguy
mlcktmguyFlag for United States of America

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?
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mlcktmguy

ASKER

Thanks