Arrays

[parksie]

The DAO 'arrays' are not arrays. They are Collections, which are accessed by a 'key', usually a String value:

Dim MyCol As New Collection
Private Sub Form_Load()
    MyCol.Add "Item 1", "My item"
    MyCol.Add "Item 2", "A different item"
    MsgBox MyCol("My item")
End Sub

They basically deal in Variants all the time, so you can add an item of pretty much any type, although there may be restrictions on indices.