Prohibiting data entry in fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I have a form w/ a checkbox field, that, if checked, indicates that the
remaining fields on the hardcopy of the form were not filled out. So, if
this box is checked, then, obviously, we do NOT want any data showing up in
the other fields on the form by mistake on the part of the data entry person.
So, in short, what I'd like is some code/Form Properties/Field Properties to
investigate that would pop up a dialog box stating that the user is
prohibited from entering data into a given field if that initial checkbox
field is checked, indicating that the remaining fields on the hardcopy of the
form were left blank. Or perhaps some sort of 'Save & Close' box that pops
up as soon as this initial checkbox field is checked (thus eliminating the
possibility that data could get entered into the other fields on the form by
mistake)?

Thank you!
 
Just add code that says "IF" some field is checked, "THEN" the locked
property for some fields is true.

Do this after the checkbox field is changed, when the form is opened, and
when the records move from one to the next (on current).

Rick B
 
Back
Top