
1st box<2nd box etc, In forms
Hi,
You wouldn't want to use an input mask for this. Use the Validation
Rule. For example, in box 2 put
Quote:
> [ControlNameForBox1].
A more useful and flexible way to do this is with the AfterUpdate event
of Box2. For example:
If Me! [ControlNameForBox2]<Me! [ControlNameForBox1] then
MsgBox("The time in this box MUST be later than the previous box.")
DoCmd.GoToControl "ControlNameForBox1"
End If
Hope this helps!!
Brenda
Quote:
> I need help, is there a way to set a input mask or something to make
> sure that the time in box 1 is less than box 2 and so on.
> I.E.
> 08:00
> 08:10
> Not
> 08:10
> 08:00