data validation in form

[GS1]

i have an IIF statement that runs to check the contents of a form before it is updated.

I was wondering if it is possible to check if no field on the form has a value? Basically, i want to add to my IIF statemnt so that a user doesn't get trapped by my validation rules firing if they have accidently created a new record and just want to get rid of it...

Thanks

G

 

[llkhoutx]

if nz(me.dirty)=false then
-no data has changed
end if

 

[Pat Hartman]

I presume your code is running in the form's BeforeUpdate event. You should not end up in there if the user has not changed any fields. It is only executed if the form is dirty. If you have a situation where you are ending up there it may be because you have written some code that is dirtying the form.

 

[llkhoutx]

Yes, it's on the form's BeforeUpdate event.