Mighty:
Arrays are automatically passed byref. So pass the array, change the row as required and it is done.
' tblPractice has fields, startdate (datetime), istudents (number),
' tclassroom (text), ID (autonumber)
' I inserted three records
Dim cn
Dim rst
Dim myarray
Const adStateOpen = 1...