I've already posted this in <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=42462&page=0&vie w=collapsed&sb=5>Access</A>, but since this control is also useful in VB, I thought I'd post it here too.

Is anyone familiar with this control? For some reason, even though I requery my form and recreate the hierarchical recordset and requery the flexgrid, I'm not NECESSARILY seeing the changed data without first going to another parent record or running through the whole process again. I've tried requerying the flexgrid twice, requerying the form itself (it's unbound, by the way), and everything else I can think of. Does anyone else have any ideas? Here's the code that gets called. CreateShapedRecSet actually generates the SQL and opens the new shaped recordset after closing and destroying the old one.

<pre>Private Sub UpdateForm()

'collapse the flexgrid

' Me.Requery

'recreate the flexgrid recordset

If Not mrst.RecordCount = 0 Then

' Set the HflexGrid control's DataSource property to the
' new recordset
Set hfgLabor.DataSource = mrst

End If 'Not mrst.RecordCount = 0

mrst.Filter = ""


'requery the flexgrid
End Sub</pre>