auto entry of a field based off subsequent record's info
I have a field that can have the values "Yes, No, and N/A". If i select N/A, i want all subsequent records to auto-enter N/A. Any ways to do this? I thought of using Get(RecordNumber), but I'm not getting any luck.