Lock Cells on a Form

  • Thread starter Thread starter Robb
  • Start date Start date
Yes you can, but we will need to know more about the details of the
circumstances under which you want this done, because you will probably
need to unlock it for different scenarios. Basically, the syntax for doing
that is:

YourFormName!YourControlName.Enabled = False
 
all i want to do is after they make a selection from a
drop down menu to be locked to where it can not be changed
ie... I take your personnel information and do a look up
by your name and one of your fields ie... SSN after I
place your information in the cell i don't want it to
change. Does this clear it up any?
 
-----Original Message-----
all i want to do is after they make a selection from a
drop down menu to be locked to where it can not be changed
ie... I take your personnel information and do a look up
by your name and one of your fields ie... SSN after I
place your information in the cell i don't want it to
change. Does this clear it up any?
the
syntax for doing
.
Click to expand...
 
Back
Top