VALID_IF , ENUM and EDIT data

[Steve_Fuller]

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?

[Kirk_Masden]

Steve_Fuller:

the previous saved choice is not shown

Interesting. I haven’t had that problem. I wonder why it’s working in my case but not in yours.

The Chinese characters are highlighted because I selected that tag a few days ago. Now, whenever I go to this menu, it looks like this.

[Steve_Fuller]

Thank you for taking the interest to reply.

I note that your example is not a required entry.

I wonder if this is the difference…

[Kirk_Masden]

Perhaps so. I’ll try to check later when I have time.

Ah, now that I think of it, it may have to do with the fact that I only change the value via the “quick edit” feature.

Are you using a form to change it?

[Steve_Fuller]

Yes, I use a form.

I’ll quickly change the Required status to see if anything happens

[Steve_Fuller]

It is the same result if I make the field Not Required

[Steve_Fuller]

Once I select an ENUM option then it works correctly afterwards!

BUT I don’t want to go through each record to fix this!!!

Any further suggestions?

[Steve_Fuller]

SOLUTION:

In my table I had a space between my SPLIT character “;” and the beginning of the next word

I have removed this space and it now works as expected

[Kirk_Masden]

Great! Glad you found a solution!!

[Steve_Fuller]

Thanks!