I have a form that includes a combobox that has the following in its on enter
event:

Private Sub cbProjectPhase_Enter()
Me.cbProjectPhase.Requery
End Sub

The query that is tied to this combox uses another field ("Cost Center") on
this form as criteria to select records for this combobox.

It works fine except when I go to the next record and click on that combobox
it removes what is showing in the previous record's combobox's field because
my selection "Cost Center" is different this time.

I understand why this happens but I don't know how to get around it. It
stores the bound information properly in the table but just doesn't show
correctly on the form. Any suggestions?