add item to array in vba
Posted on 2014-10-02
I am looping through a recordset and where an instr is found I want to add that item to aliasarray but it wont allow, i am not sure how do deal with this as the size of the array is as of yet unknown
I thought referencing it directly it would add the string.
Do Until RstAlias.EOF
If InStr(Me.[DecodeResult].Value, .Fields("sClientDescGroup").Value) <> 0 Then
AliasArray(index) = .Fields("sDesc").Value
index = index + 1