Allow Read-Only User To Update One Field

[Toby Young]

I would like to allow one of my read only users to be
able to update one field on a form.

The user is set-up as a read only user for all objects,
but I would like them to be able to update one single
field only. I don't want to use a subform with different
permissions to the underlying table.

Is this possible? Any help would be greatly appreciated.

Thanks in advance.

 

[Ken Snell]

Lock and disable all the controls except the one textbox that you want the
user to be able to update.

 

[Toby Young]

I guess I didn't word things correctly:

This user (User 1) is not allowed to update information
in the underlying table (Security Wizard). Other users
are allowed to update all fields. I would like to make it
so that User 1 can update one field only, while the rest
of the users can still update all fields.

Hopefully this is easier to understand.

Thanks for your help.

 

[Ken Snell]

On the form's OnLoad event, disable the controls if it's User1; otherwise,
leave then enabled.

I have not used the Security Wizard, so am not familiar with it. Is this
wizard preventing you from making one field available?