Setup write permission for a user

S

Shery

Hi,
I have setup permission for my Microsoft access database users. For one of
my users, I just wanted write permission. I don’t want him to be able to
edit data after he saves it. So, I gave him New Data User permission. But
the point is without hitting save for entry, the data is saving automatically
and he can’t change anything after entering data. He is using ‘tab’ key to
add new field and that is very dangerous because by hitting the ‘tab’ key
accidentally after his last field, the data is saving and he can’t edit it
anymore. Is there anyway to prevent this problem?

Thanks
 
S

Shery

Thank you very much for the code. Should i use expression builder, macro
builder , or code builder for this? I used BeforeUpdate event of my form
(the main form and not the detail, or header page part of it) and i used
expression builder and it didn't work. If the answe is that i have to use
the code builder, then, how should i use this code in there?
Thanks in advance.
 
Top