I changed some code to use the getrows method and my array is populated
I am not sure how to traverse the array.
Watch : - : arrTmp : : Variant/Variant(0 to 4, 0 to 0)
ive historically used
For index = LBound(arrTmp) To UBound(arrTmp)
but the array has four fields now from the recordset of which there was only one row I am not sure how to set the indexing to only traverse the rows and not the fields