Please do use [ code ] and [/ code ], without the spaces around your code when you post code..
AND indent your coding !! like so:
Finaly hardcode translations like this, are you sure you want to do this and not i.e. build a lookup table for it? What would happen if you ever need these codes anywhere else or if something needs changing or adding/deleting??
Tables are much easier to maintain.
AND indent your coding !! like so:
Code:
Private Sub Form_Current()
If District = "Amajuba" Then
Me.Frame181 = 1
ElseIf District = "eThekwini" Then
Me.Frame181 = 2
End If
End SubFinaly hardcode translations like this, are you sure you want to do this and not i.e. build a lookup table for it? What would happen if you ever need these codes anywhere else or if something needs changing or adding/deleting??
Tables are much easier to maintain.
