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?
Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted. Others take a little more time and effort and often providing a sample database is very helpf…
The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…