>I have a table that contains two fields (let's use state code
>and state description). What setting do I need to have to show
>both the state code then the state description in a combobox
>when it is not selected (user has not clicked on it yet)?
>
>I'd also like to see the best way to use a rowsource for this
>excercise since there are 10 options here...
Combo.RowsourceType=6
Combo.Rowsource="Mytable.State,Description"
Combo.ColumnCount=2
What do you want to see in text portion of the combo? Both fields together or just State?
Edward Pikman
Independent Consultant