[AccessD] RecordsetClone and Bookmark

Gustav Brock Gustav at cactus.dk
Wed Feb 8 01:32:11 CST 2012


Hi Asger

You should use RecordsetClone for this - way faster than calling SQL updates. And the form will be updated as well automagically.

/gustav

>>> ab-mi at post3.tele.dk 07-02-2012 23:06 >>>
If for instance I would consider looping the recordset to change some values, then using RecordsetClone and Bookmark would be more efficient than using Me.Recordset because the form wouldn't have to be updated for each move. (But actually I wouldn't use a recordset Edit/Update but a SQL Update for this...).





More information about the AccessD mailing list