I am trying to load an array with all the field names in a recordset. I am having a little trouble figuring out how to pull the field names from the table (if this is even possible). Here is my prob. rstTemp is the recordset.

Dim intCount As Integer
intCount = 0
rstTemp.Recordset.MoveFirst
Do While intCount < rstTemp.Recordset.numOfRecords
arrtable(intCount) = rsttemp.Recordset.fieldName
rstTemp.Recordset.MoveNext
intCount = intCount + 1
Wend

I don't know of an "easy" way to get numOfRecords and I have no idea how to get fieldName.