Avatar of pdvsa
pdvsa
Flag for United States of America asked on

Subform - calling procedure

Hi Experts,

Is the below correct code to reference a subform: subfrmProjects_Extended_List
I get a syntax error.
The code below is on a button on the Parent but I have added a subform and the [BuyCP] is now on the subform.

DoCmd.OpenForm "frmProjectDetails".subfrmProjects_Extended_List, acFormDS, , , , , OpenArgs:=Me.Buy_CP


Thank you
Microsoft Access

Avatar of undefined
Last Comment
pdvsa

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ryan Chong

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Mark Edwards

You can only assign the name of a subform to the .SourceObject property of the subform control on the main form.  That's how you "open" a subform.
pdvsa

ASKER

I didnt ask the question correctly.  I will ask another question. 

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23