Link to home
Start Free TrialLog in
Avatar of Lou Dufresne
Lou DufresneFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
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 Lou Dufresne

ASKER

Thanks Jim. This is a big help to me

Ldufresne