Patrick,
Thanks a million! That's what I was lookin for.
>Try
>
>ThisForm.grdResults.columncount = -1
>
>>I have a "Search" form that has a few comboboxes and a grid to display the results of the search. One of the comboboxes is used to select different tables(views) to search. I would like to put code in the InteractiveChange method that will RESET, that is totally blank out the grid when another table(view) is selected. I want it to totally remove columns, headers, etc. I want it to be totally white as it is before the initial search.
>>
>>I use a public variable, "srView" as the RecordSource of the grid. When the user clicks the "Search" button the srView variable is set accordingly and the grid is populated.
>>
>>I've tried putting this in the InteractiveChange event of my combobox:
>>
>>ThisForm.grdResults.RecordSource = ""
>>
>>But all that does is remove the records and leaves the columns and headers.
>>
>>How do I totally RESET the grid.
>>
>>Thank you.