>I feel sort of stupid now. I just noticed that the RowSource was based on a view, not the original table, so of course the data wasn't updated until I did a requery(). The problem was not with the ComboBox after all, but with this view.
>
>Thanks for your help, it certainly helped me clarify my thoughts!

Great you found the problem.