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.