Please explain this formula

[Johin.b]

Hi guys,



I am new to access db. In one of the db, I saw the following formula where there are three options available and only one can be chosen 1. By Branch 2. By Postal code 3. By Country

IIf([chkBranch]=(-1),[cmbForBranch],IIf([chkPostalCode]=(-1),[cmbSelectCountry],IIf([chkCountry]=(-1),
[List107])))

Can someone please tell me in simple english what this formula actually does?

Thanks in Advance!
Regards,
Joe

[JoeM]

If the chkBranch check box is selected, return the value from cmdForBranch,
else if the chkPostal check box is selected, return the value from cmbSelectCounty
else if the chkCountry check box is selected, return the value from List107.

[ssanfu]

BTW, the formula is missing the FALSE option in the 3rd IIF() function

IIf([chkBranch]=(-1),[cmbForBranch],IIf([chkPostalCode]=(-1),[cmbSelectCountry],IIf([chkCountry]=(-1),
[List107], "Unselected")))


If [chkBranch] is Unselected
and [chkPostalCode] is Unselected
and [chkCountry] is Unselected,
return "Unselected" (or ???)