How do I create a formula to lock fields (not records)?

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

Guest

I have created a database that is on a shared drive. There have been several
occasions where someone accidentally presses the delete button and erases the
customers name. I have no way of getting that customers name back. So, I
wanted to know if there is a way or a formula I can create so that after a
new customer has been entered, the customer field automatically locks.

Thank you
 
You could do a couple of things depending on how else you might want the user
to interact within the field.

You could use the OnExit event to change the Allow Edits property. But what
if they spelled the name wrong?

You could change the table to not allow blank entries (or Null values I
believe).

You could put code behind your close form event to check if there is
something in the fields before allowing the user to exit the form.

I am sure there are other ideas out there.

HTH
 
Back
Top