>I have a formset and one form has a grid for browsing a file. At times I need to close the file and then reopen it again. Since the grid momentarily looses its data source, it disappears. Is there an easy way to recreate the grid? Right now I'm releasing the whole formset and recreating it again. All I need is just to get that one grid back. Do I need to hard code the grid in a routine and call the routine?
>
After data source reopening you should also restore grid recordsource and column.controlsources:
With Thisform.Grid
.Recordsource="mytable"
.Column1.Controlsource="mytable.myfield1"
.Column2.Controlsource="mytable.myfield2"
***
.Refresh
Endwith
Edward Pikman
Independent Consultant