Array from ADO recordset, then display in a mesaage box
Posted on 2004-08-19
Exactly what the title says....
This is the code I have, but I don't know ow to display the array in a mesage box....
Set adoMRS2 = New ADODB.Recordset
strSql2 = "Select Product_ID from tracking_file Where Product_ID <> '" & strDTID & "' AND field_1 ='" & strSS & "'"
.Open strSql2, adoMCN2, , , 1
If Not adoMRS2.EOF Then
arr1 = adoMRS2.GetRows
MSGBOX "These are the results: " & arr1
I would prefer to have each record on a anew line, so I suppose I need to insert &Chr(13) betwen each.