Combo box cascade doesn't view record after update

D

Deki

Hello,
I have two combo boxes:
cboEscalationReason
cboEscalationSubReason

and 3 tables:

EscalationReasonTable (EscalationReasonID{pk}, EscalationReason)
EscalationSubReasonTable (EscalationSubReasonID{pk}, EscalationSubReason,
EscalationReasonID{fk})
EscalationTable
(EscalationID{pk},....,EscalationReasonID{fk},EscalationSubReasonID{fk}).

After selecting value in cboEscalationReason, values in
cboEscalationSubReason are filtered using RowSource:

Select EscalationSubReasonID, EscalationSubReason from
EscalationSubReasonTable Where EscalationReasonID=
[Forms]![frmEscalation]![cboEscalationReason].Value

I also put:

Private Sub cboEscalationReason_Change()
Me.cboEscalationSubReason.Requery
End Sub

All data is correctly recorded in EscalationTable, but when I update next
record with different EscalationReason, cboEscalationSubReason is blank.
How can I make cboEscalationSubReason show records form table?
 
Top