ItemsSelected assistance

[coopsman]

I need some quick VBA assistance in Access 2000...I am trying to take Column #3 (not the bound column) from a combo box called Manager and store it in a textbox called mgrparent after I have updated my selection in the Manager combo box. Does anyone have a quick piece of code that will help me accomplish this? Thanks.

Jim

 

[gol4]

place this in the control souce of text3
= manager.Column(2)

remember column = 0

or
in the after update event

me!mgrparent.value = me!manager.Column(2)

 

[coopsman]

thanks gol...I forgot that column starts at 0 instead of 1