Is there any way to reference the record above in any form of Query?
I want to Update a Date field where the new Date is 1 hour greater than the record above. I created a great form, with help from you guys, all works really well. Unless a group of records has been duplicated where the Date field is empty. (I have fixed this issue going forward but existing clients have old duplicates, so I need to fill the empty Dates in before they can use my new form)
Something like: NewRow, Date field = Date in row above plus 1 hour
I don't ask for much do I?
Probably you need to work with the form's RecordSetClone and use goto Previous to get to the previous Record