>>You are still missing the time when it is important to clear the grid's recordsource; you need to do this BEFORE the SQL statement that creates it's source runs. The reason this is usually important is because when you recreate a grid's recordsource while it is bound, it temporarily destroys the source, the grid "senses" this, panics, and forgets all of its settings. By clearing its recordource first, you are "shielding its eyes" from the destruction of its beloved cursor.
>
>My, but your grid has quite a personality...I can almost hear it screaming for its source :)
I guess after spending so much time with these characters... er controls, you get quite attached to them, and become sensitive to their needs. Excuse me, I have a spinner to comfort...
:-)
Erik Moore
Clientelligence