Protecting Fields

[Jeannie]

I am working on a database that will allow students to
view available dates for ushering. Everything looks great
but I have one problem. I want to protect the fields so
they can only change the usher signup field. Any ideas.
It is so easy in excel and this has to be a relational
database. Help!

Jeannie

 

[Ken Snell [MVP]]

In a form, you can disable and lock controls (controls display data from
fields when the control is bound to the field). That allows viewing but no
editing of the data in that control. This disabling/locking can be done in
the form's design view.

 

[Guest]

Thank you, thank you, thank you. Sometimes the brain just glitches and the
simplicity of the solution obsures my mind. Once again, thank you.