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.