Clearing a flexgrid

[Guest_imported]

I am currently using a flexgrid in a Access 97 application that I am developing. The flexgrid works beautifully to desplay the information in my recordset when I first open the form. However, when I change the criteria of my recordset, I am only getting blank additional rows added to my flexgrid. I need to figure out how to delete the rows containing the data from the previos recordset and also update the flexgrid to contain the new recordset data.

Thanks in advance

 

[MickB]

To clear the fexigrid you only have to input;

flexgrid1.clear

To repopulate the grid with the new recordset you open the recordset and add the results into the flexgrid. [sig][/sig]