Attached is a really rough db. I used this just as an example.
I have a close button on the subform pndata_frm. I have the button so it closes the record and then moves to the next record. The code used for this works ok if the user closes say record 1 then record 2 in order. But if they skip to say record 10 and close it, and don't close any of the records prior, it jumps back to record 2. Not sure why this is happening. Do I have this wrong? Or is there another way to do this? When you open the form open PNData_tbl. Thanks..
Code:
Me.Parent.RecordsetClone.MoveNext
Me.Parent.Bookmark = Me.Parent.RecordsetClone.Bookmark
I have a close button on the subform pndata_frm. I have the button so it closes the record and then moves to the next record. The code used for this works ok if the user closes say record 1 then record 2 in order. But if they skip to say record 10 and close it, and don't close any of the records prior, it jumps back to record 2. Not sure why this is happening. Do I have this wrong? Or is there another way to do this? When you open the form open PNData_tbl. Thanks..
Code:
Me.Parent.RecordsetClone.MoveNext
Me.Parent.Bookmark = Me.Parent.RecordsetClone.Bookmark
