Combo box to fill in Subform 1

[Steven547]

I have a combo box that is based on a table with two columns.
I have a subform, that when I click a command button, I would like it to populate the two fields on my subform, with the selected info from the Combo Box.

It works with the first column:
on click event: FieldA = me.combobox (not the exact naming, but you get the idea.)

How would I get it so that FieldB (located on subform), would equal the 2nd column in the combo box? Or is there another way to do this? I've tried having the form based off a query, etc..but haven't figure it out yet..

thanks.

 

[LisaWay]

This should work:

FieldB = me.combobox.column(1)

Regards,
Lisa

 

[Steven547]

Thank you!