Expression builder

[Riaang]

Hi,

On my form form I have 2 fileds that I need to link with one another by doing the following.

Field 1 = Letter posted.
Data required will be Yes or No

Field 2 = Reason for not posting the letter
Data required will be linked to field 1. If field 1 contains a Yes then field 2 can be blank but if field 1 contains a No then data into this field is compulsary.

How can I do this in the expression builder.

Regards

 

[Tlewman]

You might try an if statement...

IIF(Field 1= "YES", "",Field2)