Moving selected data from combo to text box 1

[jpl458]

Have a form with a text box and a combo box. Text box name is text0. Combo is called eventcomb. The combo box displays data in an event table where col1 1 is a number and is primary key,next coll is field1 and contains a list of event types. I want to select an event type from the combo box and move it to the text box. Using onclick event in combo box for vb code.

Text0.defaultvalue = eventcomb.field1

It copies the primary key to the text box not the event name. I have changed the bound field in combo, as well as other tries. but nothing works.

Would appreciate help.

Thanks in advance

jpk

 

[PHV]

In the AfterUpdate event procedure of the combo:
Me!text0 = Me!eventcomb.Column(1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jpl458]

Worked like Champ. Thanks again

jpl