Populate Automaticly

[diazr]

I'm trying to make two fields, [RELATEDTO] & [RELNAME] populate automaticly at the same time when field name [ACCOUNT] is entered by a user.

In the form "Transaction Log" in the field [ACCOUNT] I have created a event procedure in After Update (see below code). Which populates automaticly [RELATEDTO] from table "CIF ACCOUNTS" but I'm having trouble getting to populated the second field [RELNAME]. Any help would be greatly appreciated.

Private Sub ACCOUNT_AfterUpdate()
Me.RELATEDTO = Me.ACCOUNT.Column(1)
End Sub

 

[dkinley]

I suspect that your row source does not have multiple columns for you to feed the other textbox with.

See the attached db that demonstrates something similar except it updates 5 text boxes. It is set up for unbound text boxes, but the principle is the same.

-dK

 

[diazr]

Thanks, dkinley...

I was able to figure out what I was doing wrong by examining your sample database. Thanks A MILL!!