Thanks Dennis

That answers a lot of questions for me, Im had wondered about populating an array so I can use the indiviual columns to populate text boxes etc

I assume the following will work but i ll check it later

Me.TextBox1.Value = vaData(0, 0)

Me.TextBox2.Value = vaData(1, 0)

Me.TextBox3.Value = vaData(2, 0)

and so on


thanks again

If you have other places I can research around ADO and SQL please let me know

gibbo