What is the RecordSource of the second combo? It sounds like you're not refreshing the underlying RecordSource before you Requery the combo. For example, if the RecordSourceType of the second combo is an array or a view, you need to rebuild that array or Requery the view before you Requery the combo.
>I have a combo box that displays choices from a parent table and another that displays choices from a child table. The child tables combo box is populated by a query where the filter condition is the value of the first box because i want its choices filtered to be the chilr records of whatever choice is made.
>
>It all works fine for the first__value but when I click the first combo box the second one does not refilter itself. Ive tried secondcombobox.requery in the click statement of the first combo box, and ive tried this.requery in the got focus event of the second combo box.
>
>How Do i make the scond combo box requery itself?
>
>TIA
>Chris