Hey Folks,

I have a series of fields which, when a "flag" is set, must be filled

in. I'm doing it with "Validate only if field has been modified"

UNchecked since it's setting the flag that determines whether or not

the user is locked in the record until he fills everything in. The

validation calculations look like this:

not IsEmpty(RequiredFieldA) or Flag <> 1

not IsEmpty(RequiredFieldB) or Flag <> 1

etc.

So, if flag = 1, the field must be filled in. Otherwise, go ahead and

leave it blank. Flag gets set and cleared via various buttons,

scripts, etc. all being called while in the record.

I'm in a record, I set the flag = 1, I can still switch to another

record! BUT, if I type something into one of the required fields, tab

out of it, go back into it, clear it, and tab out again, it catches

the validation. In fact, I get one messagebox after the another as it

catches all of the required fields. Does anyone know why the

validation would not be consistant?

On top of that, if I just keep clicking "Revert Field" -- it

eventually lets me out! There seems to be no way to conditionally

lock a user in a record until certain fields are filled in. Any

thoughts?

Thanks,

Jeff

Thanks,

Jeff

Try an "and" operator instead of a "or"