Hi Craig

Thanks for the reply, its handy to know how to use the .nextrecordset
function anyhow. I tried to use it before but i had the syntax wrong.

Thanks again

"Craig Kelly" <cnkelly@worldnet.att.net> wrote in message
news:bLYKb.8097$214.269574@bgtnsc05-news.ops.worldnet.att.net...
> "Jarrod Morrison" <jarrodm@ihug.com.au> wrote:
>
> <snip>
>
> > Rstest.NextRecordset
>
> <snip>
>
> Although I like the use of UNION mentioned already better, to get this to
> work, you would use....
>
> Set Rstest = Rstest.NextRecordset
>
> Craig
>
>