How to populate a Videosoft Flexarray controller? (97)

[chrisjohns]

Hi,

Im hoping someone knows how to populate the cells in a Videosoft Flexarray control? To this point ive been populating a table with a recordset but im now trying to avoid copying data into a table by using this method.

My current code receives data from an SQL statement and populates a table line by line.

Set rsDAOSet = CurrentDb.OpenRecordset(strTableName)
Do Until rsRecordset.EOF
    With rsDAOSet
        .AddNew
        For intLoop = 0 To rsRecordset.Fields.Count - 1
            If IsNull(rsRecordset.Fields(intLoop).Value) Then
                If .Fields(intLoop).Type = dbText Then
                    .Fields(intLoop) = ""
                Else
                    .Fields(intLoop) = 0
                End If
            Else
                .Fields(intLoop) = rsRecordset.Fields(intLoop).Value
            End If
        Next intLoop
        .Update
    End With
    rsRecordset.MoveNext
    DoEvents
Loop