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
Speak using soft and sweet words in case you have to eat them later.