Is there a way to lock a field after the data has been enter? Thanks for the help

quote:

---

Originally posted by yalebulldog:

Is there a way to lock a field after the data has been enter? Thanks for the help

---

Eli, Eli. Eli....

Sure. Create a number field called "validation", auto enter data = 1.

Have your other field validate against that field Validation.

After you enter the data, have the number changed from 1 to 0 by script. Thereafter, as long as the Validation field =0, the data in the other field can not be changed by the user. It could be changed by script in some instances.

HTH

Old Advance Man

I make a script, and attach it to the field on the layout (so the field is a button). The script is simply:

code:

---

Allow User Abort [off]

If [isEmpty(field)]

Go to Field [field]

Else

Exit Record/Request

End If

---

If the field is empty they can enter it. If it is not empty the script keeps bumping them out. Obviously this only works if the user cannot select another layout.

Be sure to remove the field from the TAB order if you do this.

Old Advance Man

Ouch! I forgot about that... Thanks OAM.

If you deselect the "allow entry into field" option, you don't have to worry about the tab key, but the Go to field script step will still work.

In my experience, if "allow entry into field" is unchecked, there is *no way* to enter the field.

Either way, the original post was about having control over data entry, not just locking users out.