>>Is there any way of determining which field caused a record level validation to fail?
>>
>>The problem I'm having is in creating the same friendly type of user interface that my users know and expect. Assuming the data failed to validate, the form knows that the TableUpdate() has failed because it returned false, but the form also needs to know why it failed and in particular which field it failed on so it can SetFocus() to the offending field.
>>
>
>David,
>
>You might create a cursor to contain the information you need. Your validation routine would add a record each time it encountered an error and the form error processor would then loop through the records and handle the errors.

Yes...I could see that working. But it looks a bit like a work around. Is what I'm trying to do so unusual? I was sort of expecting someone who routinely uses Stored Procedures for validation purposes to jump in and tell me the way to go on this...

David