Results 1 to 1 of 1
Thread: MS Hierarchical FlexGrid
2001-05-30, 20:43 #1
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
MS Hierarchical FlexGrid
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
'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