Yes...that is correct. Your logic is failing me here. How would you know
that they've put in an incorrect amount without ALL the data?

Signature
Paul Overway
Logico Solutions
http://www.logico-solutions.com
> Thanks Paul. Wont this mean that the message will only appear once they've
> input all the data though? The form has a number of columns and rows and I
[quoted text clipped - 34 lines]
>> > TIA
>> > Tony
Sorry Paul probably not explaining myself. The form has a number of rows and
columns of figures and each row and column has a total. I want the error
messages to appear as they complete each column and row total, not when they
have completed ALL the rows and columns. Here is an idea of how the form
looks:
Col 1 Col2 Col3 Totals
Row 2 3 4 9
Row2 4 7 2 13
Row3 6 7 7 20
Totals 12 17 13 52
Is that any better?
Thanks for your help here.
Tony
> Yes...that is correct. Your logic is failing me here. How would you know
> that they've put in an incorrect amount without ALL the data?
[quoted text clipped - 37 lines]
> >> > TIA
> >> > Tony
Paul Overway - 21 Jan 2005 21:19 GMT
You're making things much more difficult for yourself than need be. You
still need to validate that they've entered the columns before you can
validate the totals. Whether you realize it or not, you are trying to
validate a SET or subset of data...which would be accomplished most easily
and logically in Form_BeforeUpdate. Otherwise, you'll have to write code
for each control AND Form_BeforeUpdate (just to be sure that your logic is
correct). It seems you're just trying to dictate the order that they enter
the information....and that really shouldn't matter at all. One person may
enter the data vertically, the next horizontally. As long as ALL of the
entries are made and they make sense, so what?
The biggest issue I see here is that you have a poor design. You're having
the user enter totals....when normal form would have them calculated
automatically. You also appear to be storing them...another no no. And
you're going to have a mess to validate here anyway...because a row total
may be incorrect while a column total is correct or vice versa. Why
wouldn't you use a spreadsheet for this anyway? I suspect you've left out
critical information from the data model shown...i.e., what does each row
actually represent? Each column? Is each row related to a date? If so,
where are you storing that?

Signature
Paul Overway
Logico Solutions
http://www.logico-solutions.com
> Sorry Paul probably not explaining myself. The form has a number of rows
> and
[quoted text clipped - 64 lines]
>> >> > TIA
>> >> > Tony