I have a form with a field defined as a combo box. The SQL where clause that controls the combo box references a field on the same form. When I first go into the form the Combo box works OK, but when I change the value of the field the combo box references it still thinks the old value is there even after it's changed. I've tried refreshing, requering, and repainting, but it still won't work. The field with the combo box is unbound. Any suggestions?