Locked Yes/No Box in a Form

  • Thread starter Thread starter Rico
  • Start date Start date
R

Rico

Hi,

I have a Yes/No check box in form. What I want to do is
locked it once the user check it, on any existing record.
Is there an easier way of doing this? Any help is highly
appreciated....Thanks...
 
Rico

Let me try to paraphrase -- if the checkbox is "Yes", you don't want the
user to change it? What if someone checks it by accident?

There are a couple places to add code:
Whenever an existing record is called up, the OnCurrent event
Click to expand...
triggers -- you'll need to decide about locking the checkbox whenever an
existing record comes up.
If someone checks the box, the AfterUpdate event triggers for the
Click to expand...
box -- you'll need to lock it if = Yes.
 
Back
Top