I would prefer the form to open on the last record I was working on.
again, that can only be done with an update time stamp.
Once I have completed an update, I want to be able to click to the next record (or several records further on) so need the entire set of records to be there
this works to do that, based on having a date field that stores the UpdateDate, which would be updated to Now() upon record saving or editing. I've coded it to work from a button click, which I'd recommend rather than arbitrarily opening the form to the record last edited or created without any choice at the time. Pardon the lame button name. I'm assuming the table has an autonumber PK field (PK_ID_fieldName in the code below). Also, I didn't have all those [brackets] so I might have goofed it up there.
Code:
Private Sub Command177_Click()
Dim rs As DAO.Recordset
Dim lngID As Long
Set rs = Me.RecordsetClone
lngID = DLookup("[FieldName]", "[tableName]", "[FieldNameWithUpdateDate]" = #" & DMax("[FieldNameWithUpdateDate]", "[tableName]") & "#")
rs.FindFirst ("[PK_ID_fieldName] = " & lngID)
If Not rs.NoMatch Then Me.Bookmark = rs.Bookmark
Set rs = Nothing
End Sub
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.