I have written the following code to run on exiting a text box it either keeps the inputted price or replces it with the current one if higher. It works up to a point but then won't let you move on to a new record have I missed something?
Private Sub COST_Exit(Cancel As Integer)
If Me.COST.Value <= Me.COST£.Value Then
Me.COST.Value = Me.COST£.Value
If Me.COST.Value > Me.COST£.Value Then
Me.COST£.Value = Me.COST.Value