Can't quite figure out the correct syntax... been trying various forms of
The aim is to requery the Form and return to the same record.Code:Dim b As DAO.Recordset Set b = Forms.Form1.Datasheet.Form.RecordsetClone Forms.Form1.Datasheet.Form.Bookmark = b.Bookmark Forms.Form1.Datasheet.Form.Requery Forms.Form1.Datasheet.Form.Bookmark = b