>Morning Naomi et al
>
>I made the modifications to the combo box. Here are my current settings:
>
>RowSource = crsSex
>Rowsourcetype = none
>boundcolumn = 2
>boundto = .t.
>
>when I run the form, the combo box doesn't have anything to display. I am able to browse both my tables v_empdemo and the cursor crsSex.
>
>In the load event of the form I placed the following sql statement.
>
>SELECT pk_sex_id, sex_desc FROM sex INTO CURSOR crsSex nofilter
>
In addition to setting RowSourceType to 2 alias did you also set the controlsource correctly? When you move between records, you need to call thisform.refresh() This should be enough for the combobox to show proper value.