>Thank you Al
>
>The idea of a cursor that I zap and repopulate is great. I'm sure that one will work beautifully. However, if I want to try the other way you suggested, how would I go about it? Will restting the proprties as I described before automatically tie it to the window, provided that I had set the properties to blank before closing it?
>
>Just in parentices, the recordSource is NOT lost. The columncount, though, is set to 0, and naturally the controlSource of all columns disappear with the column.
>
>Steven
The principle is, set all data binding settings to blank before you close the table, then after you re-open the table, set the settings back to what they were:
WITH MyGrid
.Column1.ControlSource = ""
.Column2.ControlSource = ""
etc...
.RecordSource = ""
ENDWITH
WITH MyGrid
.RecordSource = < alias >
.Column1.ControlSource = < column1 >
etc...
ENDWITH
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up