pulling second column from a combobox to appear on report 1

[Nate1749]

[Forms]![frm72]![cboWeekNum]

is the control source of the text box I have on the report. It's pulling column #1 which is the ID field, and I want it to pull column #2 (the field with the different week numbers). I've done this before, but I can't remember exactly...

-Nate

 

[CosmoKramer]

Try:

[Forms]![frm72]![cboWeekNum].Column(1)

with the (1) meaning column 2 (it's zero relative....)

 

[Nate1749]

I forgot that it started at column 0!!! I kept putting .column(2) (because I wanted the 2nd column & there are only 2 columuns) and it wasn't working. Thanks!

-Nate