Hi Arriyel,
I have it set up in the data enviroment like that. This view is only used for reports so in my onreport code (called when client presses report button), it recaptures the date parameter from the report screen and does a requery('myview'). It just doesnt requery???

Sandi

>Hi,
>
>Try adding the view in the form's data environment and set it to nodataonload = .T. Then in the Load of the form select the view and do a requery() then a form refresh.
>
>HTH,
>Arriyel
>
>>I have a strange problem. I have a view with a parameter 'statdate'. In the command window if I set the parameter, use the view and browse I see a set of records and if I change the value of statdate and =requery('myview') and browse I see a different set of records - which is correct. But within my program if I do the same thing I see the same records and the view has not requeried. What am I doing wrong. The parameter is setup as a PUBLIC variable in the BeforeOpenTables method of the form and released in the Destroy Method.
>>
>>TIA,
>>
>>Sandi Cassidy