I have a field in my table called "timestart"

I want to know how i can put the value for the new record by adding the previous record's value with a number stored as duration (which is always less than 60).

Can i make a query for this to happen in my table or how do i make this happen????

Please Help!!!

One solution if your data is displayed in a form is to store the value being carried forward in the field tag property, e.g.

me!txtDate.tag= data

when the next record is created,

If me.newrecord then _
me!txtdate = me!txtdate.tag

Note the added code to determine if you have a new record or you are merely navigating among records.