Hi
New to VBA , Can some one please correct the code below. I ve heard that a select case statement might be even better then using If case statments. can you also please show me how to use the case statement for the code below? Thank you
If Left(Me.Engine, 1) = 6 Then
Engine_Type.Value = "PMC"
Else if Left(Me.Engine, 1) = 7 Then
Engine_Type.Value = "FADEC"
else
msgbox " Engine serial does not match engine type "
End If
End If
New to VBA , Can some one please correct the code below. I ve heard that a select case statement might be even better then using If case statments. can you also please show me how to use the case statement for the code below? Thank you
If Left(Me.Engine, 1) = 6 Then
Engine_Type.Value = "PMC"
Else if Left(Me.Engine, 1) = 7 Then
Engine_Type.Value = "FADEC"
else
msgbox " Engine serial does not match engine type "
End If
End If