>Multi-colomn combo box 1

[Saxie1]

I've looked through all the help files but can't find anything on this. In Access97 I want to have a combo box with two columns, one with abbreviated month, the other spelled out. What is the syntax to reference the second (unbound) column, so that I can click "Jan" and put it in a textbox and "January" in another textbox all with one click?

Thanks for your time and expertise.

Saxie1

 

[Maquis]

you can reference the columns with the syntax:

me!textbox = me!combo1.column(0)
me!textbox2 = me!combo1.column(1)

Combo box columns are zero based so column(0) is the first column.

Maq

 

[Saxie1]

Thank you for the assist Maq. Your great.

Saxie1