i want to execute the following code, which gives me the controlsource for a
field. the IIF function needs to check the data in the field and has to
return a word
----start code:-----------------
IIf( [Customer]![Type of Customer] =1;"Particulier";IIf( [Customer]![Type of
Customer] =2;"Dierenhandel";"Dierentuin"))
------end code------------
this always generates an error!
someone an idea why???
txs

Eric Van Camp
apeiron
Trolieberg 74
3010 Kessel-lo
t:016/35.69.99
f:016/35.57.90
mobile:0479/598.599

--0-1713727436-1016558796=:37667
Content-Type: text/plain; charset=us-ascii


 What is the error message? Is [Type of Customer] also the name of the field that you are putting this expression in? If so, then
that can cause a problem also. When I use the IIF function in expressions, I use a comma to separate the sections of the statement
not semicolons like so...
IIf( [Customer]![Type of Customer] =1,"Particulier",IIf( [Customer]![Type of
Customer] =2,"Dierenhandel","Dierentuin"))
I hope some of this helps.
 
  Eric Van Camp <eric@a...> wrote: i want to execute the following code, which gives me the controlsource for a
field. the IIF function needs to check the data in the field and has to
return a word
----start code:-----------------
IIf( [Customer]![Type of Customer] =1;"Particulier";IIf( [Customer]![Type of
Customer] =2;"Dierenhandel";"Dierentuin"))
------end code------------
this always generates an error!
someone an idea why???
txs

Eric Van Camp
apeiron
Trolieberg 74
3010 Kessel-lo
t:016/35.69.99
f:016/35.57.90
mobile:0479/598.599



Lonnie Johnson, ProDev, Builders of MS Access Databases
Let us build your next MS Access database application. 
http://www.galaxymall.com/software/PRODEV 

Send and Receive payments for free with PayPal:  http://www.paypal.com/refer/pal=Y6TYF7YF8E2JG


---------------------------------
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage

This is a multi-part message in MIME format.

------=_NextPart_000_063F_01C1CF69.4D734440
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Eric,

It appears you are using a semi-colon instead of a comma to delimit the 
function.

Walt