Read only records in a table

  • Thread starter Thread starter WN
  • Start date Start date
W

WN

I am trying to figure out how to make certain records in a table read only if
a field in the table satisfies a certain requriement. Basically, I want to
make sure that no one can change data for a specific record if their is an
entry in the "resolved" field.

Thank you for your time.
 
If users don't have any direct access to the tables or queries, you can set
this up using a form.
Your form would check the value for the "resolved" field in its On Load and
On Current events, when the form is doing edits.
If there is an appropriate value in the "resolved" field, that entire record
can be locked by locking the appropriate controls on the form.

Jeanette Cunningham
 
Back
Top