Textbox value has to be less than another

[waq963]

Hi, Basically i have a Scoring form where a user enters a score but there is a maximum possible score textbox. How could i code the score textbox to only accept values that are less than the maximum score textbox? Thanks

 

[DCrake]

Simply use a validation check on the after update of the control

If Me.Score > 100 Then
   MsgBox "Maximum value exceeded, revise and retry",,"Error"
   Me.Score = ""
   Me.Score.SetFocus
End If

 

[waq963]

Cheers Mate, worked perfectly.