 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008How do I access a parameter in a sub form?
I have a main form that contains a sub form. I have a form that prompts for the parameters (on open) but the sub form prompts for the paramters before my form is called. If I eliminate the form and use the paramters that the sub form prompts for then I don't know how to name them in the main form. Appreciate any help you can give me! John To refer to controls on a subform, you use something like (untested): Forms!YourMainForm!YouSubFormControlName!Form.YourControlOnTheSubForm  SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > I have a main form that contains a sub form. I have a form that prompts for > the parameters (on open) but the sub form prompts for the paramters before my > form is called. If I eliminate the form and use the paramters that the sub > form prompts for then I don't know how to name them in the main form. > > Appreciate any help you can give me! That helps but how would you use that format to refer to a prompted parameter value? > John > [quoted text clipped - 11 lines] > > > > Appreciate any help you can give me! John We may not share the same definitions... What do you mean by "a prompted parameter value"? In what context? SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > That helps but how would you use that format to refer to a prompted parameter > value? > > > John > > > > To refer to controls on a subform, you use something like (untested): Forms!YourMainForm!YouSubFormControlName!Form.YourControlOnTheSubForm > > > I have a main form that contains a sub form. I have a form that prompts > > for [quoted text clipped - 5 lines] > > > > > > Appreciate any help you can give me! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.