REFERENCING DATABASE FIELDS TO TEXT BOXES

[TNN]

I'm using Access 2000 database with vb6.0 and I want to somehow reference the fields in a databse to text box indexes on a form. The text boxes are a control array. I want to be able to load the values in the database fields into the text boxes per the text box indexes. The fields will hold values other than the text box indexes.

Anyway to do this????
TNN Tom

 

[MikeCox]

I'm not sure what you're trying to do...? From your post it sounds like your answer is just to set the DataSource (Adodc1) and the DataField properties for each text box. That will bind each control to each field, and the textboxes will display the info in the field it's bound to. Is that what you're asking? Difference between a madman and a genius:
A madman uses his genius destructively,
A genius uses his madness constructively.

 

[adamr1001]

The above post was exactly right. just drop down the menu and select which field you wish to plug through the particular text box. rawk.

 

[edderic]

with Recordset (your recordset or table)

txttext(0).text = !name & ""
txttext(1).text = !Adress & ""
txttext(2).text = !Zip
.Close
End With Eric De Decker
vbg.be@vbgroup.nl