>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 :)