Combo box not return description to table

[crann]

Help

My combo boxes are not returning the actual combo box values back to my table, instead in the table it is displaying the combo box data list number i.e 1,2,3,1,5,1 etc where it should be displaying a property address

if that makes sense

grateful for any help

Jon

 

[namliam]

That should be the value of your BOUND COLUMN, which should be a Primary key of another table.

Things are supposed to work that way....

 

[CJ_London]

you can refer to the description by referring to the appropriate column - the first column being 0 (bound column starts from 1)

e.g. a controlsource for control might be

=mycbo.column(2)