question | how to change a value with choice in a combo box

[mikichi]

hi,
i have a two column that one stores a professions and other stores a number of the profession like that:

number	professions
1	singer
2	police man
3	teacher

"number" column is a combo box, that boundColumn property is two.
i want that in the form when i choose a value in a combo box i will see the profession in other text box in my form.
if i choose 2 in combo box i see in a other text box in my form police man.
thank you,
miki
p.s:sorry on my horrible english

[June7]

I assume the combobox is multi-column.

Expression in textbox can refer to column index of combobox. If the profession is in column 2 the index is 1 because index starts with 0: =[comboboxname].Column(1)

[mikichi]

thank you!!
i write in "source control" =[comboboxname].Column(1).
but now i have other problem. its doesn't update my data base. because i change the source control!
thenk you,
miki

[June7]

And it shouldn't. Should not save the profession name if you are saving the ID number. Save one or the other, not both.

[mikichi]

And it shouldn't. Should not save the profession name if you are saving the ID number. Save one or the other, not both.

lol! i dont think on this ><
thank you very much. its exellent forum