PeterBaileyUk
asked on
add item to array in vba
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].Va lue, .Fields("sClientDescGroup" ).Value) <> 0 Then
AliasArray(index) = .Fields("sDesc").Value
index = index + 1
Else
End If
.MoveNext
Loop
I thought referencing it directly it would add the string.
Do Until RstAlias.EOF
If InStr(Me.[DecodeResult].Va
AliasArray(index) = .Fields("sDesc").Value
index = index + 1
Else
End If
.MoveNext
Loop
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.