D
Dan @BCBS
My form has a subform (Link Child & Master field = ICNNO).
On that subform are two fields "CA_Name" and "CA_Decision" and they are both
Combo Boxes.
A different list is displayed in "CA_Decision" based on the choice made in
the "CA_Name" field.
This subform is for multiple entries which all pertain to the same ICNNO.
Example: ICNNO = 123
CA_Name = MG
CA_Decision = 1
CA_Name = BH
CA_Decision = 29
Everything is fine to this point:
The problem is when a change is made to "CA_Name" it changes all the
CA_Decision lists on the other entries to the list associated with the
CA_Name just entered.
Private Sub CA_NAME_Change()
If Me.CA_NAME = "MC" Then
Me.CA_DECISION.RowSource = "Select * from t_Recommend where
[DEC_TYPE] in ('1','2','4','5','7','14','22','25')"
ElseIf Me.CA_NAME = "MG" Or Me.CA_NAME = "AG" Or Me.CA_NAME = "TL" Then
Me.CA_DECISION.RowSource = "Select * from t_Recommend where
[DEC_TYPE] in ('1','2','4','5','14','22','31')"
ElseIf Me.CA_NAME = "BH" Or Me.CA_NAME = "BM" Then
Me.CA_DECISION.RowSource = "Select * from t_Recommend where
[DEC_TYPE] in ('3','29','32')"
ElseIf Me.CA_NAME = "GC" Then.......
HELP>>>>>>>>> I'm Confused...
On that subform are two fields "CA_Name" and "CA_Decision" and they are both
Combo Boxes.
A different list is displayed in "CA_Decision" based on the choice made in
the "CA_Name" field.
This subform is for multiple entries which all pertain to the same ICNNO.
Example: ICNNO = 123
CA_Name = MG
CA_Decision = 1
CA_Name = BH
CA_Decision = 29
Everything is fine to this point:
The problem is when a change is made to "CA_Name" it changes all the
CA_Decision lists on the other entries to the list associated with the
CA_Name just entered.
Private Sub CA_NAME_Change()
If Me.CA_NAME = "MC" Then
Me.CA_DECISION.RowSource = "Select * from t_Recommend where
[DEC_TYPE] in ('1','2','4','5','7','14','22','25')"
ElseIf Me.CA_NAME = "MG" Or Me.CA_NAME = "AG" Or Me.CA_NAME = "TL" Then
Me.CA_DECISION.RowSource = "Select * from t_Recommend where
[DEC_TYPE] in ('1','2','4','5','14','22','31')"
ElseIf Me.CA_NAME = "BH" Or Me.CA_NAME = "BM" Then
Me.CA_DECISION.RowSource = "Select * from t_Recommend where
[DEC_TYPE] in ('3','29','32')"
ElseIf Me.CA_NAME = "GC" Then.......
HELP>>>>>>>>> I'm Confused...