>Hi Sandi, I do this all the time so it must be something else.
>
>Cheers,
>
>Andrew
>
>>I did that and it doesnt help. Has anyone ever built a parameterized view where the parameter is a date, and got it to work?? Maybe that is where my original problem lies.
>>
>>Sandi

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