read array into a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have calculated data that is stored in an array called DeltaLw. (1 text and
5 numeric fields, variable number of records. Some fields may be empty.) I
want to open a subform that displays the data. I created a temporary table
called TempDeltaLw but can't find a way to read the data from the array into
the table. Any suggestions?
 
I think I found the answer. I added the code:
Set rst = dbs.openrecordset("TempDeltaLw")
With rst
.AddNew
.Fields![Lw 2] = DeltaLw(2, 2)
.Update
End With
I still need to add a loop to read the entire array but this assignment
seems to work.
 
Back
Top