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

Tina Norris Fields tinanfields at torchlake.com
Sat Jan 3 12:03:07 CST 2004


Thanks Gustav, I will try that - Tina

Gustav Brock wrote:

>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.
>>    
>>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>



More information about the AccessD mailing list