Hi David.
>> Is there some way to requery a 6.0 grid without having to re-define grid properies? <<
The easiest way to do this is to define a parameterized view and use that as the RecordSource for your grid. Thn, when you have to change the grid's contents, you just Requery() the view with a different paramter.
Another technique that I use is what I call a "safe" select. I define an updateable cursor in the form load and use that as the RecordSource of the grid. Then, when I want to requery the grid's contents, I zap it's RecordSource, do a SELECT into a temporary cursor, and append from the temporary cursor into the grid's RecordSource. Zapping the grid's RecordSource will not reset the grid because it does not close the RecordSource.
Marcia
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