The Basics are:
1) wqhen the form closes, save the unique record ID. I normally use a table.
2) When the form loads, look to see if ther eis a saved unique record ID for the current user. If there is, then "find" the record. If it exits in the current record set for the form then move the bookmark to that record.
Sample code to find a record"
Me.RecordsetClone.FindFirst "[PrimaryKeyFeild] = " & lngPrimaryKeyToFind
If Me.RecordsetClone.NoMatch Then
MsgBox "Code not fiinf record id: " & lngPrimaryKeyToFind
Me.Bookmark = Me.RecordsetClone.Bookmark
You will just need to add code to sore the Primary Key value and then retrieve.
Edited by: HiTechCoach on Tue Aug 7 21:51:43 EDT 2007.