>Hello everyone,
>
>Haven't see you for a long long time.
>
>I have a grid in a form normally. The recordsource is a local view. When I update the form, I want the view update, too. But, when I fire 'requery()' from one of the button in the form. A error message came out that 'This command is not allowed in local table.'(i forgot the exact message, something like that). How?????
>Requery() is a very common command to update the view. Why it can't run in my case? Do I have another choice?
>
>ps.i miss vfp very much.
>
>Sunny

Hello, Sunny.

REQUERY() can only be used on views. It looks like when you issue REQUERY() the current alias is not the view like you think. For this reason, it's a good idea to get into the habit of specifying the alias of the view want to requery in the REQUERY command:

=REQUERY("MyView")

This way, you won't ever be surprised by the current alias.