Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 69
  • Last Modified:

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?
0
mlcktmguy
Asked:
mlcktmguy
1 Solution
 
Rey Obrero (Capricorn1)Commented:
that is a good plan, but what is the purpose of doing this?
0
 
mlcktmguyAuthor Commented:
Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now