Remove loop for .location copy from recordset (Norrie)

**robtuby** · 03-09-2015, 08:06 AM

Hi

I hve the following code and Norrie suggested using .location copyfromrecordset.

how and where would this go?

Please Login or Register  to view this content.

If you could amend the code above that would really help as i have several modules that are almost identical.

Rob

**robtuby** · 03-09-2015, 08:58 AM

all sorted, thanks

**Norie** · 03-09-2015, 08:59 AM

Did you try what I suggested?

Please Login or Register  to view this content.

Re: Remove loop for .location copy from recordset (Norrie)