Lou Dufresne
asked on
MS Access 2013 - Load a Query into the record source of the subform using VBA Code
I have a main and subform and wish to load a query into the subform record source using VBA but I don't know the syntax to do this.
The main form name is: F-100-00 StartUpMain
The subform name is: F-100-01 CFR_Pivot-All Records
The query name is: Q-100-01 CFR_Pivot-All records
I want to use VBA code to make the record source of the subform (F-100-01 CFR_Pivot-All Records)
"Q-100-01 CFR_Pivot-All records" when the code is executed.
Question: Using the information listed above provide me with the correct syntax so that I can add this code statement to my VBA Sub process
Thanks for your assistance.
Ldufresne
The main form name is: F-100-00 StartUpMain
The subform name is: F-100-01 CFR_Pivot-All Records
The query name is: Q-100-01 CFR_Pivot-All records
I want to use VBA code to make the record source of the subform (F-100-01 CFR_Pivot-All Records)
"Q-100-01 CFR_Pivot-All records" when the code is executed.
Question: Using the information listed above provide me with the correct syntax so that I can add this code statement to my VBA Sub process
Thanks for your assistance.
Ldufresne
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ldufresne