I feel so dumb because there has to be a better way of doing this. I am trying to prevent a field from being filled out if it is being done out of order. Access does not seem to recognize the fields when I use it in an array or loop....I must be doing something wrong with the syntax but the following code is the only thing that I can get to work.
If [curAmount1] <= 0 Or [curAmount2] <= 0 Or [curAmount3] <= 0 Or [curAmount4] <= 0 Or [curAmount5] <= 0 Or [curAmount6] <= 0 Or [curAmount7] <= 0 Or [curAmount8] <= 0 Or [curAmount9] <= 0 Or [curAmount10] <= 0 Or [curAmount11] <= 0 Then
MsgBox "Please fill the payment blocks in the proper order as displayed", 0, "ERROR, ERROR, ERROR!!!!"
[curAmount12PD] = 0
[dteDate12PD] = Null
[curAmt12] = Null
End If
If anyone has any suggestions it would be helpful.
Dave