Storing two fields from a dropdown

[puforee]

I have a dropdown selection (on a form) that shows two fields from a table. It stores one field in the forms underlining table. How can I set it up so it stores both fields from the dropdown into two fields in the forms underlying table?

Thanks,

 

[Remou]

You could update a hidden, bound control to the second field in the after update event.

 

[puforee]

Example please. Let's say the bound field is "3-Letter Code" and the second field that I need to store is "Customer Name".

Can you show mw and example?

 

[Remou]

In the after update event of the combo:

Me.txt3LetterCode=Me.cboCombo.Column(1)

Where txt3LetterCode is the name of a bound control and 1 is the number of the column that contains the data, starting numbering from zero.

 

[puforee]

Thank you ....got it and will put it in tonight.

;-D