Combo Box Bound Column Display

[Krysti]

Is it possible to have the bound column of a combo box not display in the dropdown list, but display in the text box when I choose it?

The fields in my combo box are:

Agent#
AgentName

Right now, the bound column is Agent# and I have the width of it at 0" so only the AgentName will be displayed, but after I choose the AgentName, I want the Agent# to be the actual value displayed. Does this make sense? I can't seem to figure out a way to do it.

Thank you for any help

Christy

 

[Mile-O]

On the AfterUpdate() event of your combobox put this line of code, changing the object names to suit:

txtYourText = cboYourCombo.Column(0)

 

[Krysti]

I knew I probably didn't explain that right. I actually want the Agent# to be displayed as the value chosen in the actual combo box, not in a separate text box. Maybe this isn't even possible... (?)

 

[Krysti]

Okay, thanks. I just wanted to make sure I wasn't missing something and that there was a way to do it like I wanted. Oh well!!

Thanks again for the replies

Krysti