vba courses london - Access Combo VBA

hi,

In my Orders form i have a combo box which determines where the order will take place. There are only 2 selections atm as we only have two sites..

What i need this combo box to do is instead of saving "Gatwick" when it is selected i need it to replace it with GWO- as this will be combined with an Order number eg (GWO-0001) and this GWO-0001 will be the actual Order number.

I wrote this code which obviously doesnt work otherwise i wouldnt be posting here! Is there any chance you could correct it for me and explain what i did wrong?

Much Appreciated!

Private Sub Combo96_AfterUpdate()

Dim ComboOption1 As String
Dim ComboOption2 As String

ComboOption1 = "Gatwick"
ComboOption2 = "Woking"

If AfterUpdate(Me!Combo96) = "Gatwick" Then
ComboOption1 = "GWO-"
End If

If AfterUpdate(Me!Combo96) = "Woking" Then
ComboOption1 = "WWO-"
End If

End Sub