Try to call 'requery' method. If it not helps - write following code in requery of combobox and call it:

this.RowSource = ''
this.RowSourceType = 0

use in mycursor2

this.RowSourceType = 3
this.RowSource = 'SELECT ...'

HTH.


>I am using a drop down list box. It uses an sql statement (rowsourcetype = 3-sql statement) to populate the list part (rowsource). the sql statement is:
>select exp;
>from city_area_codes;
>where cl_city = city;
>into cursor mycursor2
>
>city is a public variable.
>now, if the value of city changes at some point, is there anyway to get the combo box to re-evaluate the sql statement so that the values in its drop down change?
>Thanks,
>Ryan