>This is a major problem I've had to. The following code seems to work,
>
>this.grid.recordsource=' ' ( you need the space)
>this.grid.recordsource='mynewalias'
>
>Don't ask me why this works.

it works because the grid doen't loose it properties because u change
the recordsource - it does so because this is wht the grid does when
the table connected to it closes (don't ask me why MS gave us this "feature")
and this why the table (as far as the grid knows) doesn't close

anyway another way is to use parameterized views - they don't close when u requery (as I said all this can be found in the VFUG tips)

Arnon