[AccessD] Form as Subform - Query Fails - Why?

Hi Tina

Try with

  Between
   [Forms]![fInstructions]![subYourSubformControlName].Form![BeginningDate]
  And
   [Forms]![fInstructions]![subYourSubformControlName].Form![EndingDate]

/gustav


> Hi John,  

> Thanks for the reply.  I think I have not been completely clear about my 
> quandary.  The parameter query selects records based on the following:

> Between [Forms]![fCalendar]![BeginningDate] And 
> [Forms]![fCalendar]![EndingDate]

> - which works fine as long as one sets the dates by opening fCalendar as 
> a stand-alone form.

> I made a form with a series of instructions, hoping to guide my user 
> from step to step without having to remind the user to set the dates 
> first in the fCalendar -
> the idea was to embed an instance of the fCalendar in the instruction 
> form - set the dates right here in what is now a subform of the 
> instruction form.

> If one sets the dates in the embedded instance of fCalendar, the query 
> does not find its parameters.  Well, say I to myself, I probably need to 
> tell the query where to find those date textboxes, but I do not find a 
> way to identify them other than as they are already identified .  Is 
> there a collection other than [Forms] I need to find?  When I examine my 
> fCalendar through the subform control, I see all the correct textbox 
> names - it certainly appears to be the same form - why does setting its 
> dates not provide the necessary parameters to the query?  I don't see it.