Second column in a combo box to a new field

[SOMSteve]

I am trying to bind the first column to one field and the second column to a different one, by using the afterupdate event of my combo box. I know it has to be easy, but I don't know what coding to use to assign the value of my second column to another bound text box on my form within that procedure. I've looked on the forum and found a description of this process, but no code to go along with it. Any assistance you can offer would be greatly appreciated, thanks!

-Steve

 

[Trevil]

In the 'After_Update' event, try something like:

Me.txtSecondField = Me.ComboX.Column(1)

Learn from the mistakes of others. You won't live long enough to make all of them yourself.

 

[SOMSteve]

Thanks Trevil, that worked great!