Combo Box Fills another field

[tcheck]

This seems easy but it's not coming to me. I created a combo box (it has 2 fields, Account Number and Display Name) in a temp form that contains all the account numbers from a table that has had account numbers entered. Sometimes the Display Name is input if it is different from the account name other times it is left blank.

I would like to take the field number 2 (Display Name) from the combo box and put it into the temp form that also has a field named Display Name after the Account number is entered if the display name is not blank from the combo box.

Does this make sense?

[pbaldy]

Like this?

http://www.baldyweb.com/Autofill.htm

[tcheck]

I tried the following

Private Sub AccountNumberSelect_AfterUpdate()
Period = PeriodSelect
DisplayName = AccountNumberSelect.DisplayName
End Sub

AccountNumberSelect is my combo box name and Display name is the second field name in the query. When I do an update I get

Compile Error:

Method or data number not found.

[pbaldy]

Why don't you try what I suggest in my link?

[tcheck]

Sorry I thought I did. Do I use Column(2) instead of the name of the field?

[tcheck]

I used Column(1) and that worked. Thanks for your help.

[pbaldy]

Yes. The 2 would be the number of the column containing the desired data, and is zero based, so 2 would refer to the third actual column.

[pbaldy]

Oops, we were typing at the same time. Glad it worked for you.