How can i create a dynamic array and add to it?
How can i get the info from it possibly like
for i = 0 to Ubound(myarray)
str = str + "," & Myarray(i)
After you have declared a dynamic array you will have to use the Redim statement to redimension the array as you go. If you know how many elements the array will hold or a "no more than" it would be best to set it to this value originally. Ex. Dim MissingCks(100) as Integer.
The help system for Visual Basic that ships with Access can give you more details.