Unbound Text box must display values from Combo boxes

[Wolfgang]

Hi,
I have a number of combo boxes (Linked to tables) 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 are
: 1 2 , where 1 is the category_ID for Hardware, etc.

I would like the following to be displayed :
Hardware AGP Video Adaptor

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

Thanks for a great forum!

Wolfgang

 

[Fizzio]

There is a couple of ways to acheive this. It depends if you want the info in 1 text box or several. It is acheivable in 1 box as follows;
Make sure that the row source of the combo boxes show the description of the item also.

Set text box to unbound
In the recordsource of the text box

=CategoryComboBox.Column(1) & " " & SubCatComboBox.Column(1)

where column 1 is the 2nd column (I am assuming this is where you have the description.)
On the AfterUpdate value of both combo boxes, have the event code to read Me.Refresh which will refresh the form.

HTH

 

[Matze]

Thanks guys!
Actually I was looking for the second code, but I'll use both of them in my datbase.
)

 

[Wolfgang]

Thanks for the help!