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:

Date: Record:
3/9/06 10
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!

IF Me.txtRecord < Day(Me.txtDate) Then
MsgBox "you typed in a number prior to the date!",vbOkOnly
End If