>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.
If it's not broken, fix it until it is.
My Blog