value from Combo Box not displayed in text box

[Wolfgang]

Hi,

I have a number of combo boxes (Linked to tables) with categories and sub categories in them; I would like an unbound text box to display the summary of the selections in the various combo boxes.

EG:
Category: Hardware
Sub Category: AGP Video Adaptor

The values displayed in the text box is: 1 2 , where 1 is the category_ID for Hardware, etc.

I would like to show the actual value and not the ID number?

Thanks for a great forum

Wolfgang

 

[Rich]

In the after update event of combo 1 Me.TextField = Me.ComboName.Column (1) where column 1 is the second column of your combo.
HTH