Silly question....

[Silverblood]

i've got a field in a form where u need to pick gender(in dutch)
Now there's an Attention further on and i need the proper attentionin english= Male=Sir,Female=Madame) Which is in dutch: Male= M = De heer
Female = V = Mevrouw, Unknown = O or B = De heer/mevrouw, So my code became:
=IIf([Geslacht];"M";"De heer";(IIf([Geslacht];"V";"Mevrouw";"De heer/mevrouw")))

Can some1 please tell me what i did wrong?


Kind Regards
SilverBlood

 

[RuralGuy]

Try:
=IIf([Geslacht]="M","De heer",IIf([Geslacht]="V","Mevrouw","De heer/mevrouw"))
If [Geslacht] is a control on the form then try:
=IIf(Me.Geslacht="M","De heer",IIf(Me.Geslacht="V","Mevrouw","De heer/mevrouw"))