I have 2 records in vDayTran.
When I debug below coding, it will go thought the loop 2 times then exit.
When first jump into the loop, i get the values from the vDayTran first record.
But in the second loop, i get the same values as the vDayTran first record, not the values from the second record.
Code:Set gblDb = CurrentDb Set gblRst = gblDb.OpenRecordset("SELECT * FROM vDayTran", dbOpenDynaset, dbSeeChanges) Do Until gblRst.EOF DoCmd.RunSQL ("Insert into Tranlog VALUES ......") gblRst.MoveNext Loop gblRst.Close Set gblRst = Nothing gblDb.Close Set gblDb = Nothing