How do i lock a field, but still be able to add new entries?

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

Guest

I am designing a form and want to lock a specific field so it cannot be
edited, but would still like to enter entries into that field. Any
suggestions?
 
Confused...

Are you trying to have a function populate it without user input, or what?
Right now it sounds like you want them to be able to edit, but set it so it
can't be editted...
 
You can enter values in a Locked control (not a field, fields are in tables,
controls are on forms) and assign it a value programmatically. Locking it
only prevents a user from making manual changes.
 
Sorry for the confusion... hope this helps:

At work, we identify clients by a ClientID number that we get from a
separate database. When I input the ClientID # into OUR database, it will
pull all the information from the other one. I want to set the ClientID
control so I can continue to add/edit entries... just not edit the ClientID
control for entries that are ALREADY in our database. We have had employees,
accidentally, add or delete characters from the ClientID control, which makes
it very difficult to locate records. Thanks for any help you can offer!
 
I'm not sure I, completely, understand... hopefully, this scenario will give
you a little more info:

At work, we identify clients by a ClientID number that we get from a
separate database. When I input the ClientID # into OUR database, it will
pull all the information from the other one. I want to set the ClientID
control so I can continue to add/edit entries... just not edit the ClientID
control for entries that are ALREADY in our database. We have had employees,
accidentally, add or delete characters from the ClientID control, which makes
it very difficult to locate records.

Thanks for any help you can offer!
 
Okay, no problem. My earlier post describes how it can work; however, where
you do it will depend on the behaviour of your form. I assume you initially
have to enter the client id to pull that data from the other database. Once
you have the client number, then just lock the control that the client id is
in and the user will not be able to change it. This also assumes it is the
same control. If that is the case, then you will have to have a place to
unlock it so the user can look up another new client id. If it is a
different control, then as soon as you have the client id, you can assign its
value to the other control. That control can be locked all the time.
 
Back
Top