How to get data from access into textboxes in vb6?

Hi everyone
I'm using ADO to automate access 2003 and I know how to get the data into textboxes only from one Field at a time.

I need to get data from one single cell to one single textbox at once like in this example:

DataBase:
http://img202.imageshack.us/img202/6391/dataq.png

and this is my form:
http://img24.imageshack.us/img24/3310/form1a.png

and it should look like below after I click on the (get data from data base) button:
http://img693.imageshack.us/img693/8874/form2.png

I hope it's clear for everyone.

I really need help with this and i made it with pictures to make it easier :)

Thank you in advance
Joye

What if there are more data than textboxes?

You could try several ways
-You say that you know how to get the data into textboxes only from one Field at a time,
then do it that way.
Get data, fill one text box, get next data fill next text box and so on...

-Or use a datagrid control or a flexgrid control even a listview control

Quote:

---

Originally Posted by jggtz

-Or use a datagrid control or a flexgrid control even a listview control

---

Thank you for your tips I started learning and trying FlexGrid and guess what?
It seems to be fixing the problem :)
ON MY WAY to solve it so soon...