This could be working out the same way as if you had a UDF.
Is the base view parameterized?
Requerying a view based on another view will not requery the first view.
Close all tables before recreating the view.
Close the base view before requerying this view.
See if those things help.
>Larry,
>
>In this case, no UDFs
>
>This is a view based on another view.
>I just tried to open the view in the Database Designer and resaved it. The view then return incorrect information. When I recreate the view, I get the View definition has been changed message.
>
>Any other ideas?
>
>TIA
>
>Rex
>
>>This problem can occur if you call any functions in your view, open the view NODATA and then subsequently requery it to populate it. The view will build itself based on the first record in the table to determine structure.
Insanity: Doing the same thing over and over and expecting different results.