Data Validation

[Bechert]

Hello, I have a continuous sub-form on a main form.
I need to be able to validate the data entered on each row of the sub-form as well as perform contextual validation between rows, including when a row with specific values is not present.

I also want to ensure when a validation error occurs the user cannot exit the main form until the error is corrected.

Where should this validation take place?

Thanks,
Bill

 

[John Big Booty]

I believe the validation would need to take place in the Before Update event of the field.

 

[Bechert]

Thanks John, the Before_Update works for the fields on the current record.

I also need to be able to do detect, based on the Treament Code value (e.g., 97001) on one record, that a record with Treatment Code 'G8988' exists.


Bill