Hi Gary,

Thanks for the suggestion. I am using this method because I want to step through the returned data set which you cannot do (as far as I can tell) when using a standard (SELECT, INSERT, DELETE, UPDATE) query in the design view.

I am a VB 2005 newbie so may be completely mistaken in my belief!