Solved Temp Dynaset subform (1 Viewer)

[oxicottin]

Hello, I have a series of Public Subs that run and collect data to a table tbl_Delay like below. How do I add saving the same data to a temp table called tbl_TempDelay and I can figure out the clearing of the temp table before the new cycle runs.

What needs added to save the same data to the temp table as well?


Set db = currendDB
Set rst = db.OpenRecordset("tbl_Delay", dbOpenDynaset, dbSeeChanges)
With rst
.AddNew
!TimeDeayBegin = plcDelayStart
!TimeDelayEnd = plcDelayFinish
!delayHours = delayHours
.Update
End With


 

[CJ_London]

same code, different recordset - tblTempDelay rather than "tbl_delay"

 

[theDBguy]

Or maybe something like.

INSERT INTO tbl_TempDelay
SELECT * FROM tbl_Delay