Recent content by jmceuin

I do agree, but I do not want the users to have a backdoor. Since it is a database I have direct access to the tables while the users are restricted to the forms provided from the switchboard. If needed I could create another form to modify if not just going straight to the tables, but I find...

Mr. B. Thanks. In this case the Box number must never be changed. Once in the system I don't want the users to ever change it. If needed, I will just go into the table and make a correction, but for audit purposes I need it to stay in once it is there.

John A, thank you so much. That works just as I need it to do.

I am putting a simple database to track off site storage boxes. I have a field for the box number. It is set no duplicates. I further need to prevent the user from changing the field if it has data (not null) already but allow a new record to be created. I tried to use undo after update (before...