Thanks, Erik - I found the answer to my questin in the KB. The solution is to re-set the recordsource in the refresh:
THIS.RecordSource=THIS.RecordSource
Your suggestion is a good one, but I like to put the code into the object as much as possible - hopefully good OO techniques....
>>I know I've asked this before, but how the heck do I force the SQL grid source to be re-queried? Since the source is not a table or view, it doesn't seem to respond to a requery(), and the grid does not have a requery method!
>>
>>TIA
>
>I don't know the answer to your question, because I never use RecordSource = SQL. I find it much more easy to manage setting the recordsource to a cursor created by an SQL statement. If you put the code that does this in a method, you can rerun the query whenever you want.
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site