Requery combobox

[szag via AccessMonster.com]

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?

 

[Klatuu]

Requery the combo in the form current event:

If Not Me.Newrecord Then
Me.cbProjectPhase.Requery
End If

 

[szag via AccessMonster.com]

Thanks!

Requery the combo in the form current event:

If Not Me.Newrecord Then
Me.cbProjectPhase.Requery
End If

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

[quoted text clipped - 13 lines]

stores the bound information properly in the table but just doesn't show
correctly on the form. Any suggestions?