Content changes every Monday @ 1AM!! Check back once per week. Learn! Review! Test Yourself!
Arrays in Access VBA use a 0-based indice. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.
Dim MyArray As VariantDim i As Integer MyArray = Array("Mike", "Lisa", "Felicia", "Nathan") If UBound(MyArray) > -1 Then For i = 0 To UBound(MyArray) MsgBox (MyArray(i)) NextEnd If