Combobox Question

[Trojnfn]

I setup a combo box where I specify the data to be pulled from a table. The table just contains the primary key (id) and a name, which is what I want loaded in the combobox pulldown.



When I run the form, the names appear but when I select, the id is written to the table instead of the name.

What settings am I missing and why is it taking the id instead of the name ?

[boblarson]

Actually it is functioning the way it SHOULD work. You should NOT be storing the name, but you should be storing the ID.

[hertfordkc]

I'm not clear on the problem, but the two combobox properties which come to mind are: 1) Number of columns, and 2) Bound column, which may be what you want to change for whatever reason.