Validation of a caluculated field.

[jake7363]

Hi,
I am tring to use a msgbox along with a validation rule for a calculated field which does not allow the user to progress until the data is corrected.

There are three fields involved: TimeDateStart, TimeDateEnd and TotalTimeUsed. The formula is below:

TimeDateEnd-TimeDateStart= TotalTimeUsed.

The idea is if the TotalTimeUsed is a negative number, a message box appears indicating that the data input is wrong. That part I can do, but I am unable to stop the user from being able to go any further until the problem is fixed.

Any suggestions will be helpful.

Thanks in advance,
Jake

 

[rainman89]

what about clearing the input of the txtbox so that they have to reenter?

 

[jake7363]

The problem with that is that they do not have to re-enter...they can just continue leaving the field empty. Good idea, though..

 

[rainman89]

make it so they cant leave the field blank by adding another condition!

 

[jake7363]

Normally that would work but the record does not all get entered at once, so the only condition for completion is if the number is negative. The field can remain empty while other data is entered at different times. That is what is hanging this whole thing up.

 

[rainman89]

which one gets enetered first? the start time or the end time? or does it matter?