Macro in form

[amit82]

this Dumb thing is really bothering me.

I have a VBA code which works fine in a form_tracker.
But the Vba code does not work the same form tracker is used as a subform.

help appreciated guys please..

Here is the code

Private Sub Experience_Key_Exit(Cancel As Integer)
'On Error Resume Next
expk = Experience1
If expk > 4 And expk <= 7 Then
Forms![Tracker]![Experience Key] = 2
ElseIf expk > 0 And expk <= 4 Then
Forms![Tracker]![Experience Key] = 1
ElseIf expk > 7 Then
Forms![Tracker]![Experience Key] = 3
Else
Forms![Tracker]![Experience Key] = 0
End If
End Sub

 

[amit82]

Done Guys..

Just added main form name and it worked..