>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.

There are several solutions for this problem. The one I like and use is called 'safe-select'. Do a quick google search on "Andy Kramek Safe select" and read the article.

The other solution is

thisform.grid.RecordSource = ''
do query
thisform.grid.RecordSource = 'myCursor'