How to populate previous record with next record value

[asrivas1]

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

[orange]

See http://allenbrowne.com/subquery-01.html

There is a section on Get the value in another Record