>Thank-you, it worked a treat!
>
>Andy

You must've used the cursorlocation on your recordset. By looking at the vrs.open() I was under the impression that test was your connection instead of you command object. Actually there is no cursorlocation property for the command object, only the connection and recordset objects have it.

But the important thing is that you got it to work.