1. I have a form class with a grid. All the grids properties are set at design time. The user wants to be able to "zap" the grid and start over doing input. Because of missing information or other delays the user can not always finish there input. After the input some processing is done and the resulting data is uploaded to a mainframe. If the upload "blows" the user needs to go back and correct the grid or clear it and start a clean input. I have tried to set the table exclusive, zap it, reset the recordsource from a button on the form. This leaves the columns the size of the field and not the original width (which is wider). If I call a method to reset the widths, I get a column unknown error.
If someone knows how to set a table exclusive, zap it with out loosing the grid or its appearance and having to write tons of code to reset the properties, it would save me from committing Hari-Kari. I have spent way to much time for this aggrevation.
Help...please, Thanks.