I have a database with a series of layouts that are worked through in sequence when entering data. In the last layout, there are 3 fields with a "not empty" validation option. The problem is that as I enter new data into one of the earlier layouts, I am constantly getting a validation error message telling me to change layouts and fill in the fields that require a value.

I only want this validation error message to come up when I am actually in the layout that contains the validated fields. Is this possible to do?

Thanks in advance.

Cooperj

You might want to add the following to the validation calculation:

Case (Status(CurrentLayoutName) = "LayoutName", <Validation Calculation Here>, 1)

Where LayoutName is the name of the layout you want the fields validated on. I haven't tested this, so let me know how it goes.

Thanks Peter for the suggestion, but I couldn't get it to work. I am not using any validation calculations - just ticking the "non-empty" option in the validation dialog box. The fields are yes/no fields. Could you suggest a validation calculation that might fit?

Thanls again for ypur help.

Cooperj

Case(Status(CurrentLayoutName) = "Validate", not IsEmpty(Field), 1)

Where Validate is the name of the layout you want validation to take effect on, and Field is the name of the field you are validating. I found it helpful in my tests to have 'validate only if field has been modifed' unchecked.

Hope this helps.

Peter, you're a marvel. Thanks for your help.

Cooperj

My pleasure, cooperj