E
egibson
I currently have a combo box that the user chooses the value and then 3 other
fields on my form are updated depending on the selection. However, the field
that the user chooses contains a dash. The correct information is populating
in the 3 fields, but not in the orginal combo box that the uses chooses.
Please see my example and code:
1.) User chooses this field from drop down
Carrier: 12502 - 01
12502 - 99
12358 - 99
2.) Then these fields are populated
State1: PA
State2: PA
Name: Rest of Pennsylvania
3.) If the user first chooses the 12502 - 01 then that number stays in the
carrier field, however if the user chooses 12502 - 99 the correct information
in the below fields populate, but the Carrier field stay at 12502 - 01.
It might be because of the dashes. I'm not sure. Any help is appreciated.
Here is my code:
Private Sub Combo196_AfterUpdate()
Me.[Locality Name] = Me.[Combo196].Column(1)
Me.[State] = Me.[Combo196].Column(2)
Me.[State LAB] = Me.[Combo196].Column(3)
Me!Region.SetFocus
End Sub
Thanks,
Erin
fields on my form are updated depending on the selection. However, the field
that the user chooses contains a dash. The correct information is populating
in the 3 fields, but not in the orginal combo box that the uses chooses.
Please see my example and code:
1.) User chooses this field from drop down
Carrier: 12502 - 01
12502 - 99
12358 - 99
2.) Then these fields are populated
State1: PA
State2: PA
Name: Rest of Pennsylvania
3.) If the user first chooses the 12502 - 01 then that number stays in the
carrier field, however if the user chooses 12502 - 99 the correct information
in the below fields populate, but the Carrier field stay at 12502 - 01.
It might be because of the dashes. I'm not sure. Any help is appreciated.
Here is my code:
Private Sub Combo196_AfterUpdate()
Me.[Locality Name] = Me.[Combo196].Column(1)
Me.[State] = Me.[Combo196].Column(2)
Me.[State LAB] = Me.[Combo196].Column(3)
Me!Region.SetFocus
End Sub
Thanks,
Erin