Using shit+tab to go to the previous record

[Jmsteph]

I am having problem with the below code. The form is used so that employee's can log each transaction they have processed. When I use the below code to exit the contract number it no longer allows the employee to tab back to a previous record.


Private Sub Contract_Exit(Cancel As Integer)
'This checks the production server to see if the policy has been set up yet. If it has not it stamps the product name NEW in the product field is we know to update it. If it is set up it will pull the product name from the server.
If IsError(DLookup("[pm_plan_code]", "dbo_T_POLICY", "[pm_policy_number]='" & Me.Contract & "'")) Then
Me.Product.Value = "NEW"
Else
Me.Product.Value = DLookup("[pm_plan_code]", "dbo_T_POLICY", "[pm_policy_number]='" & Me.Contract & "'")
End If
End Sub