Visual Basic Concepts

Using the Hierarchical FlexGrid with a Hierarchical Recordset

You can use the Hierarchical FlexGrid with a hierarchical Recordset to view relational information. You can display this information to the user while ensuring that the original data remains secure and unchanged, or you can add cell-editing features to your Hierarchical FlexGrid by adding a text box to the form. When the Hierarchical FlexGrid is bound to a hierarchy of Recordsets, you can display grouped and related Recordsets using bands.

Note   Data must be bound to your Hierarchical FlexGrid before performing this procedure. To do this, see Binding Data to the Hierarchical FlexGrid.

To use bands when displaying hierarchical Recordsets in a Hierarchical FlexGrid

1. Right-click your Hierarchical FlexGrid, and then select Properties from the shortcut menu. The Hierarchical FlexGrid's Property Pages dialog box appears.
   
   
2. On the General tab, set the BandDisplay. See Formatting a Band for a description of each band display.
   
   
3. On the Bands tab, select a band from the Band box. This list of available bands is based on the Recordsets in the Command hierarchy. For all bands, the name of the Command that generates the Recordset is shown in parentheses.
   
   
4. Modify the properties of each band as necessary. See Formatting a Band for more information.
   
   
5. Click OK to apply the band properties to your Hierarchical FlexGrid and close the Property Pages dialog box.