>What properties will I set for a combo box if I want to display in a combo box the second field or field no. 2 while i want to save the field no. 1 in the control source?
> control source = table.field
> rowsourcetype = fields
> rowsource = field1,field2.
>
>Thanks for ur reply.

With Combo
 .rowsource="table1.field2,field1"
 .boundcolumn=2
Endwith