>Thanks for quick reply. I am sorry but I don't think I have understood your answer properly.
>Could u please explain it again.
>
>Thanks
>Mark
Add some coding to disallow user to enter non proper time!
Method 1:
Use Combox / ListBox for Time part and Default it to 9.00 am etc.
Method 2:
At LostFocus() or Valid() Prompt user to enter the time or Assign the
default time to it!
e.g.
if this.value - Date(this.value) = 0
Replace StaffInOut.InTime with this.value + Time(DateTime())
endif
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.