what is the main reason why cloning is done to tables in Access VBA
code?
Tables aren't cloned in VBA code. However, Recordset objects can be cloned
and forms have the Form.RecordsetC lone Property. Those are generally used
for searches and for comparing with a "before" and "after" data set.
Comment