Re: How do I access a parameter in a sub form?

From: JohnGraeagle <JohnGraeagle@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Sun, 18 May 2008 15:18:03 -0700

That helps but how would you use that format to refer to a prompted parameter
value?

"Jeff Boyce" wrote:

John

To refer to controls on a subform, you use something like (untested):

Forms!YourMainForm!YouSubFormControlName!Form.YourControlOnTheSubForm

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"JohnGraeagle" <JohnGraeagle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BEBA6FCB-4DE9-41B1-968F-F8774B31C56F@xxxxxxxxxxxxxxxx

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!

Follow-Ups:
- Re: How do I access a parameter in a sub form?
  - From: Jeff Boyce

References:
- How do I access a parameter in a sub form?
  - From: JohnGraeagle
- Re: How do I access a parameter in a sub form?
  - From: Jeff Boyce

Prev by Date: Using mouse to scroll down a combo list
Next by Date: Re: Using mouse to scroll down a combo list
Previous by thread: Re: How do I access a parameter in a sub form?
Next by thread: Re: How do I access a parameter in a sub form?
Index(es):
- Date
- Thread

Relevant Pages

Re: Extended Multi Select List Box to Sub Form
... Microsoft Office/Access MVP ... the listbox and the subform are based on the LineItem table. ... "Jeff Boyce" wrote: ...
(microsoft.public.access.formscoding)
Re: Extended Multi Select List Box to Sub Form
... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ... the listbox and the subform are based on the LineItem table. ...
(microsoft.public.access.formscoding)
Re: Field value as default on subform
... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... If your main-form/subform ... What are you pointing that subform at? ...
(microsoft.public.access.gettingstarted)
Re: There is an invalid use of the .dot or ! or invalid parenthses
... If that's a date/time data type field, you might need to compare to a null. ... Microsoft Office/Access MVP ... part of corresponding subform. ... "Jeff Boyce" wrote: ...
(microsoft.public.access.formscoding)
Re: Field value as default on subform
... BeforeUpdate in Access HELP. ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... What are you pointing that subform at? ...
(microsoft.public.access.gettingstarted)