Hey, that's a great idea. Thanks!


>Hi Michelle,
>
>Set the ColumnCount property of you combo to 3 (or the number of fields in your table). Then use the ColumnWidths property to set what you want to display. eg. if you just want loc to come up, set columnwidths to : "0,[Width of your Combo],0". Only loc will come up.
>
>Alternatively, you could set the RowSourceType tof the combo to SQL and add "SELECT loc, client_num from [TABLENAME] ORDER BY loc INTO CURSOR [CURSORNAME]"
>
>That way you won't have to change the ColumnCount and ColumnWidth as be default it will display the first column, but you will still have access to the client_num via CURSORNAME.client_num
>
>Hope this Helps.
>