I have a form that is repeating a field in the details section of the form. This field will be repeated depending on how many records I indicated (i.e. Number of days). What I am now trying to do is indicate whether or not I am typing in a number that is smaller than the previous day. For example:
3/10/06 9 <---- I need a message box to pop up telling me I have typed a smaller number.
I am not sure how I can compare records because in my form they are they same field repeated multiple times. Is this possible to do this way? If not, how should I change it up to check for this type of error?
I really appreciate any direction on this!