I have taken an example from these pages to use a Valid_If statement to load the choices into an ENUM. This works very well for me as the ENUM is copied across a number of forms so having them load from a table is great.
However, I’ve noticed that when I edit data the previous saved choice is not shown, which prompts the user to reselect the data choice - this can lead to mistakes.
Interestingly, even though this ENUM is a Required field, as shown by the *, selecting NEXT does not produce an error and when the form is saved the existing data still exists!
Is there a method for the edited form to show the underlying table data when editing?