RowSource in combo box

[Bryan]

Can I set a combobox rowsourcetype = table/query & the
rowsource = select name,id from table. Have the combo box
only display the name, and retrieve the id to use in an
insert stmt?

 

[Alex Dybenko]

you have to set row count =2, column width to ;0
this with hide second column with id
and set bound column to 2
HTH