DataCombo, Text Boxes and Datbase

Hi,

I have a form with 9 textboxes with the name txtFields(Array) and a datacombo. The text boxes are connected to the database using ado code ( adPrimasyRS ). and a datacombo is connected to the same database using ado data control(Adodc1).

The data combo is not enabled at form load, when click edit or add, then it gets enabled to allow a user to pick Name which will be displayed in one of the txtFields.

the form is debtor and creditor transactions which has, Trans_Date, Acc_No, Acc_Name, Details, Cell No, Group, Type, AmountOwing and AmountPaid

Debtor and creditor records are created in another form, i want when a user clicks on the name, the Account Number, Account Name, Cell No, Group and Type to be automatically loaded.

Hope u can understand my explanation.

Thanks in advance.

Lil