Lock Cells on a Form

  • Thread starter Thread starter Robb
  • Start date Start date
R

Robb

After data input can you lock down a cell on a form so
that it can not be changed.
 
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
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
combo box locked 4
Locking a unique form 17
View data on forms 1
Record Locking 2
Word Lock specific drop downs on a Word Document 0
Form Suddenly Became Non-Editable? 1
Locked Records 2

Back
Top