enter text instead id in combobox

[civl_eng]

hi all, in a dynamic combobox inside form i use other combobox row source , but when i add new row in form only enter id number instead text combo box in table while display text in the combobox inside form.

in file subject when i entered new person information and add, in table enter number of dynamic combo box instead text.

, Please Help me.

[ranman256]

if you do not want to enter the ID, hide the ID column
if the columns are
[ID],[SUBJ]

set the col.widths = 0;2
then the user can pick the Subj. but the ID can still be the bound column.

[civl_eng]

thanks alot, yes this Correctly shows name [SUBJ] in combobox, but when user pick then add new record, show [ID] in table instead [SUBJ]

[ssanfu]

Just an FYI,

"Type" and "Key" (field names) are reserved words in Access and shouldn't be used as object names.
Plus they are not very descriptive. "Type" of what? "Key" for what?


List of reserved words: http://allenbrowne.com/AppIssueBadWord.html