Can someone please tell me why this will not work?
Me.Destination is a combobox with values of KWA ROI MAJ WAK
TxtTOTALWEIGHT is Unbound Calculated field
Me.TxtMAXWEIGHT is Unbound Text box
Private Sub TxtTOTALWEIGHT_AfterUpdate()
If Me.Destination = "KWA" Or Me.Destination = "ROI" Then
Me.TxtMAXWEIGHT = "14200"
Else
If Me.Destination = "MAJ" Or Me.Destination = "WAK" Then
Me.TxtMAXWEIGHT = "14500"
End Sub
Me.Destination is a combobox with values of KWA ROI MAJ WAK
TxtTOTALWEIGHT is Unbound Calculated field
Me.TxtMAXWEIGHT is Unbound Text box
Private Sub TxtTOTALWEIGHT_AfterUpdate()
If Me.Destination = "KWA" Or Me.Destination = "ROI" Then
Me.TxtMAXWEIGHT = "14200"
Else
If Me.Destination = "MAJ" Or Me.Destination = "WAK" Then
Me.TxtMAXWEIGHT = "14500"
End Sub