I opened the view as no data on load and in the DE BeforeOpenTables I set THISFORM.Enddate = date(). It still does it!!!!!! What gives??????

Sandi


>Either way. (BTW, for the second option I'd always use ?m.TheDate to avoid possible conflicts with a field name in the current work area.)
>
>If I were using the ThisForm option, I'd open the view NODATA in the load (or the DE), set the date in the init with thisform.TheDate = date() and then do a requery(), again in the init
>
>If I were using the memory variable option, I'd open the view NODATA in the load (or the DE), set the date in the init with local TheDate, TheDate = date() and then do a requery(), again in the init
>
>Cheers,
>
>Andrew
>
>>
>>I was afraid of that! WHen you set up the parameter in the view, do you
>>SELECT actdate from blahblah WHERE actdate <=?Thisform.TheDate or
>>SELECT actdate from blahblah WHERE actdate <=?TheDate
>>
>>When you set the date in the form do you, set it in the Form.Init like
>>TheDate=date() or
>>THISFORM.TheDate = date()
>>or somewhere or somehow else?
>>
>>Thanks for your help
>>
>>Sandi