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

Hi Gustav,

I tried the syntax you gave me, and although it is always possible I 
screwed up in the typing, I don't think I did.  The message box still 
came up looking for the parameters.  

So, I tried another tack.  I made a copy of my fCalendar, renamed it 
frmAcknowledgeCalendar, and expanded it to accommodate the other 
controls I want.  Great!  My queries all work.  For the time being my 
needs on this are met, but I am still very curious about what I am 
missing to make the original idea work.  This one ends up LOOKING like 
the original idea, but it isn't really what I started with.  

Now, on to the next bit.  As the last step, I want my user to click a 
button to launch the Word form document, which will be kept in the same 
directory as the little database.  Here is the wizard-created event 
procedure to simply launch Word:

Private Sub cmdOpenWordDoc_Click()
On Error GoTo Err_cmdOpenWordDoc_Click

    Dim oApp As Object

    Set oApp = CreateObject("Word.Application")
    oApp.Visible = True

Exit_cmdOpenWordDoc_Click:
    Exit Sub

Err_cmdOpenWordDoc_Click:
    MsgBox Err.Description
    Resume Exit_cmdOpenWordDoc_Click
   
End Sub

What I want to do is edit this sub to force it to open 
TLA_Acknowledge_Form.doc.  I know this is eminently do-able, but I'm 
uncertain of my command language here.  I think I saw something on this 
subject  a little while back on this list, but I'll be lazy and ask - 
what do I need to do to tell it to open my form document?

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