MSHFlexGrid row number problem

From: BugIto (anonymous_at_discussions.microsoft.com)
Date: 03/19/04 

Date: Fri, 19 Mar 2004 10:56:12 -0800

I currently create an ADO recordset and connect it to my MSHFlexgrid control using the following line:

set flexgrid.datasource = rsValue (where rsValue is a valid recordset).

My data comes across ok. I then have the user click on a row to process more code with the values of the cells. However, as soon as a different query is ran and new data is posted in the MSHFlexgrid control, the row numbering of the grid is out of whack. It will be a full row or two off when I'm debugging. It seems as though I need to do something in between my queries to this flex grid. What can I do to "refresh" (this doesn't do it) the control each time?

Thank you