There's no easy way to do it in the table, but it's not hard at the form
level. In the form's Current event handler, change Me.AllowEdits to True or
false depending on the status of the current record. Current fires a couple
of times before there is a valid current record, so you need some error
handling to ignore the errors trying to read data before it's ready.
Now, if you do want to handle it at the table level, you can give users
read-only permission on the table, and create a query that returns only rows
that are not completed, then use the Owner Permissions option to allow users
to edit records through that view. The problem with this approach is that you
don't one view of the data that allows viewing everything, and editing just
the non-completed records, but it does give the user just the permissions they
should have given the states of the records.
On 18 May 2004 22:29:40 -0700,
la*****@ntlworld.com (Vic) wrote:
Dear All,
I have a database of laboratory records in Access 2000. There is one
form which acts as an interface to input experimetal data. This form
incorporates information from several tables. I have a flag (yes/no
field) indicating whether a particular experiment (one record) is
completed (ie all data belonging to that record is inputted and
quality controlled). What I want is that when I change the flag to
"yes" the particular record would not be editable any more (only
viewable), but other records (where the flag is not set) could still
be accessed.
How can I achieve this? Any input, ideas are welcome...
Thank you: Viktor