Hi Peter,

You've to call combobox Requery() method every time it's RowSource changes.

>Good night,
>I have setup a combo box to display data from a sql. The sql display data related from a field within the form. Whenever I update that field the cursor does no refresh and retains the previous data.
>
>The combo box code is as follow
>BOUND COLUMN - 2
>CONTROL SOURCE - indooragent.pol_statno
>ROW SOURCE - select pdstation.pol_stat,pdstation.pol_statno from
> pdstation where pdstation.pol_div =
> thisform.cboPD.Value into cursor cur_pd order by pol_div
>ROW SOURCE TYPE - 3 - SQL
>
>DESTROY EVENT - IF USED("cur_pd")
> USE IN cur_pd
> ENDIF
>
>Please can anyone assist
>
>Gracias
>
>P. Ghervis