Hi Guys thanks for the responses,

i have been so busy fixing some post implementation bugs i almost forgot i had even posted this. I got the answer i expected anyway, i didn't think there would be a way.

Westconn - that is an interesting idea to use a disconnected recordset, and one i will try in the future i just dont have any time to really rewrite it now so i will leave it as is.