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 > > >