I use CursorAdapter for displaying to a grid. It doesn't tear down the grid when you CursorRefresh().


>I have a search form that finds records by QuoteID, Customer Part Number, Project Name, etc.
>
>I have a dropdown list that the user can use to set the order of the search. The user sees a grid holding the results of a SQL statement that was create in the LOAD event. When the user puts in some characters in the search textbox control, to narrow the search a bit, I re-execute the SQL statement against the same base table called Quotes, and tha search is basd on what was enteresd into the textbox.
>
>I know that the results of the SQL are good, but my grid goes blank. I know I've used something in the past called Requery, but I think that was in local and remote views. Is there something similar to make the data appear in the grid once you've re-executed the query? Do you have to reset the RecordSource? I am thinking that this is the answer to my problem of the blank grid, the RecordSource.