Compare two records in the same recordset

[topher23]

So I'm working on this new project that involves comparing the machine settings for a product against the machine settings for the next product run to see which machine settings need to be changed, then allotting an amount of time for the changeover based on which machine settings are different.

What I'd like to know is: is there a way to compare these two records in the same recordset against each other directly, without generating a second recordset or using array variables? Due to the complexity involved in the data, the routine already has 3 recordsets and several variables, including at least one array. If it's at all possible, I'd like to avoid creating more memory-hogs unnecessarily.

[ADezii]

You can 'Clone' the Recordset which is not the same, and does not carry the same overhead, as creating an additional Recordset.

[topher23]

Thanks Adezii! Since I've only ever needed to clone a form's recordset, I didn't even think about cloning a code-created recordset. Good tip!

[ADezii]

Let us know how it works out.

[topher23]

Works great, no problems. I like the solution.