jscooper Posted April 24, 2003 Posted April 24, 2003 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
Recommended Posts
This topic is 7868 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now