DAO recordset management

[svolkmann]

I've come upon a strange anomaly. One thing I don't like is working in ADO thereby slowing down processing time. I like to work through DAO and refresh the screen.



I have been replicating the form.recordsource to a record set with one statement: set rs = me.RecordsetClone
Then, while updating the records of the rs ( a clone of the those on the screen), each rs.Update would force the screen to flash. So, if there are 57 records on the screen, there would be 57 flashes.

Fix: transfer the form record source to a variable, and set the rs to that query.
SQL = Me.RecordSource
Set rs = db.OpenRecordset(SQL)

I figure control keeps a link to the form record source if one uses
set rs = Me.RecordsetClone

[RuralGuy]

Do you have a question?