Combobox issue

[maluna]

Hi,

I have 4 tables :

Model [ModelID, ModelName]
Description [DescID, ModID, Description Name ]
Parts [ PartnumberID,DescID,Partnumber]

Calls [cat, desc,number]

I built a dymamic combobox base on tables (Model, description and Parts ) which is working pretty well however the results which are being recorded on Calls table are showed only in ID's.

How do I get the values selected in my combobox ???? i.e


I have attached an image as example.



thanks in advance

[RuralGuy]

Bind the ComboBox to the Column you want saved. In your case the Bound Column is probably Column 1 and should probably be Column 2.

[maluna]

I have tried to do it.

When I change combocategorie to bound 2, combodescription gets blank !

[RuralGuy]

Use the ComboBox wizard to create the ComboBoxes. It knows how to store which ever column you want.

[weekend00]

One cobom box can only have one value and can be bound to only one column. is it right?

[RuralGuy]

A ComboBox can have a RowSource that displays several field but only one of them can be bound to the ControlSource of the cbo. You can however use the AfterUpdate event of the cbo to copy all of the fields in the RowSource of the cbo to different controls on your form. There are other ways to do it as well.

[maluna]

Even using Wizard I am having the same issue....

why ?

I am attaching my db. If someone can give me a hand I would appreciate !

[RuralGuy]

I now see you are using a Cascading ComboBox which changes things a bit. It will take a little while to arrange things so it works.

[maluna]

No worries ...

in the meantime I am still tryng to find a solution !

thanks a lot mate !