Solved

Obtaining SubForm Information from Main From

Posted on 2016-11-09
2
50 Views
Last Modified: 2016-11-10
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
Comment
Question by:mlcktmguy
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 41881390
that is a good plan, but what is the purpose of doing this?
0
 
LVL 1

Author Closing Comment

by:mlcktmguy
ID: 41882390
Thanks
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question