ms accsess and vb6

[abu taher]

some data entry in some field. like:
ID name amount
01 taher 100
02 kamal 200
01 taher 500
I don't know what data entry in field. in my vb project i have some textbox. I want one textbox show the Id: 01 and other text box show the (total of id 01) amount: 600. like:
ID amount
01 600
other textbox show the total amount of id 02 and then id 03.........
how I do It.

[debasisdas]

you want to create a group of textbox for each Id ?

[abu taher]

please then......

[debasisdas]

but it will be impossible to create as many number of text boxes as number of records grows in the database

[abu taher]

you right.