Valid If expression for SELECT Ref list AND column comparison

[Shaun_Stringer]

Hi,

So I am using an ENUM base Ref and Valid_If expression rather than a REF type column to provide the specific list of items I want people to choose from, but I would also like to use the Valid_If expression to make the selection invalid if it does not match a previous column in the form. Can I do both?

Ex: SELECT(RefTable[Key], [Column] = "xyz", FALSE)    AND    [Previous Column] = [_THIS]

If the choice from the provided list does not match the value from the previous column, this should be marked invalid and show the Invalid Value Error. If it does match, all is well.

@Steve - You have frequently solved my problems. Help from anyone is appreciated.