Many thanks Clunietp
The silly thing works for me as well but I can almost swear the same combination of code failed everytime I tried it in the past!!

WHAT IF I don't want to use any of the controls including the text box how can you access the record set that i want using the ADO Control.