Hello all.
I'm trying to lock field1 for edits if field5 is true. However, I need field1 to remain locked for all other records.
I've successfully done this with a macro under On Click, but it unlocks the column for all records:
If [field5]=0 then SetProperty
Control Name field1
Property Locked
Value False
This can be accomplished with VBA, just more familiar with macros