how to connect MS Hflexgrid to data environment in runtime

[nqueen]

Hi,
we built a hierarchical flexgrid following a step by step book that showed us how to connect that mshflexgrid through data environment which works. For now, the felxgrid shows all options of a products but we need to show the options of a specific product only when that product is selected through our combo box.
The problem now, is that we did that connection using the properties. we don t know how to hardcode the connections from a data environment so taht we can use some code to be able to show only the options needed for a product.

would you have any idea of how to do it?
thanks

 

[kennedymr2]

etc.

This bit of code may help you, ie put .recordsource in Form_Load...

Private Sub Form_Load()

xx = InputBox("Which Date ????", "", Date)

datPrimaryRS.RecordSource = "select xxxDate,xxxVenue Where xxxdate= " & "#" & xx & "#" & " Order by xxxDate,xxxVenue"

datPrimaryRS.Refresh