I have to populate enddate for previous record with Start date of new record. For example,
If old record record#1, StartTime=9:00Am
New Record record#2, StartTime =10am
Then I need to update record #1 with end time =10am, I tried this code but it gives me error, please help
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim tm As Variant
Set db = CurrentDb
Set rs = db.OpenRecordset("qryDailyTimetrackingMaxct")
rs.MoveLast
tm = rs!Time
rs.MovePrevious
rs![EndTime] = tm
rs.Update