Unanswered: possible to make parts of a recordset read-only?
In a table I have a "verified" Yes/No field.
On one of the forms I want to give users access to update those of the records that are NOT verified yet, but still be able to see the verified ones.
I think I can do a check for that value on the form's OnDirty event (any better choice?), but really want to know if there are smarter/easier ways of doing this. Can I set a selected subset of the Dynaset/Recordset to read-only, for example? Not only at the time of opening the form, but also directly updated if any other user is verifying a record that is currently in another users loaded form's recordset...