Hi All -

Is it possible to display more than one true value in an IIf function. For example, I have 2 bounded fields on a form - Place and Language. In the validation rule for Language, I want to display that if Place = 'Mexico', then Language can be 'English' or 'Spanish'.

IIf([Place]='Mexico', 'English' or 'Spanish', 'Other')

This doesn't work. How can i do this ??

Thanks

How is the user selecting these values? You should use cascading combo boxes such that if Place = Mexico, Language selections are limited to English or Spanish.

You can also create rules using select case statements that will not limit you to one Place, like:

Select Case Place
   Case "Mexico"
     If Me.Language <> "English" AND Me.Language <> "Spanish"
          'some action
     Else
          'some other action
     End If
   Case "Spain"
     If Me.Language <> "Spanish" Then
          'some action
     Else
          'some other action
     End If
End Select

Put this on the Before Insert and Before Update events of your form.

Anyway, maybe not as pretty, but works as well. Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

Well, it looks like you're using strings as the true/false statement. So you would do this:

IIf([Place]="Mexico", "English or Spanish", "Other")

If it's Mexico, the string is "English or Spanish".
If it's not Mexico, the string is "Other".




Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

I think he wants to check for a value of "English," or a value of "Spanish," not set the value "EnglishorSpanish." So either a nested IIF, or a nested conditional will have to do it.




mmcdonal

Look it up at: http://wrox.books24x7.com