>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only