>I'm attempted to display two fields of a table with codes and descriptions to a cbo but i only want to save the code with the record in the main table. I've tried to use columns, but can't figure them out, especially not how to add info to the second column.
>Ideas are appreciated.
>
>Thanks..
>
>Jason Nance
Jason,
Try with these properties :
Rowsourcetype : SQL
Rowsource = select description, code from mytable into cursor somecursor
Columncount : 2
Boundcolumn : 2
Style : dropdownlist
Columnwidths : 100,0
Controlsource : yourtable.code
Cetin