Hi,
You can do it at the table design level or at the BeforeUpdate event for the
FORM (since you need both fields filled... imagine someone begining with
box2 and then, filling box1 ).
The test
Nz(Me!Box1, 0) <= Nz(Me!Box2, 0)
may do the job, considering also the possibility that any of the two box is
empty.
Hope it may help,
Vanderghast, Acess MVP.
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
>Please help.