i am comming up with errors adding data to my dynamic array
Code:
    Do Until dyna.EOF
          
          
          myarray(UBound(myarray)) = dyna("InterviewerShortDesc")   
    dyna.MoveNext
    Loop
im trying to extract data from my database and store it in an array called my array ???
its a dynamic array how do i add data to it???
here is my atemt to do it but i cant get it right!!
thanks for all your help