Problem with IIF statment

[Tony Williams]

Can someone tell me what's wrong with this rather complicated IIF statement,
I keep getting syntax error message.

=IIf(IsNull[txtsubject],(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]=Forms!frmMain!Subform1![txtmemnbr]")
& " " &
DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]=Forms!frmMain!Subform1![txtmemnbr]")),(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]=Forms!frmMain!Subform1![txtempmemnumbera]")
& " " &
DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]=Forms!frmMain!Subform1![txtempmemnumbera])))

Thanks
Tony

 

[geppo]

Can someone tell me what's wrong with this rather complicated IIF
statement, I keep getting syntax error message.

This way if the criterions are type text

=IIf(IsNull[txtsubject],(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]='" &Forms!frmMain!Subform1![txtmemnbr] &"'") & " " & DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]= '"&Forms!frmMain!Subform1![txtmemnbr]&"'")),(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]="&Forms!frmMain!Subform1![txtempmemnumbera] &"'") & " " & DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]="&Forms!frmMain!Subform1![txtempmemnumbera] &"'")))> Thanks> TonyThis way if the criterions are type numerical =IIf(IsNull[txtsubject],(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]= '" &Forms!frmMain!Subform1![txtmemnbr]) & " " & DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]= '"&Forms!frmMain!Subform1![txtmemnbr])),(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]="& Forms!frmMain!Subform1![txtempmemnumbera]) & " " & DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]="&Forms!frmMain!Subform1![txtempmemnumbera])))--CiaoGeppo

 

[Tony Williams]

Sorry geppo still getting syntax error?
Tony

Can someone tell me what's wrong with this rather complicated IIF
statement, I keep getting syntax error message.

This way if the criterions are type text

=IIf(IsNull[txtsubject],(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]='"
&Forms!frmMain!Subform1![txtmemnbr] &"'") & " " &
DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]=
'"&Forms!frmMain!Subform1![txtmemnbr]&"'")),(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]="&Forms!frmMain!Subform1![txtempmemnumbera]
&"'") & " " &
DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]="&Forms!frmMain!Subform1![txtempmemnumbera]
&"'")))> Thanks> TonyThis way if the criterions are type numerical
=IIf(IsNull[txtsubject],(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]=
'" &Forms!frmMain!Subform1![txtmemnbr]) & " " &
DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]=
'"&Forms!frmMain!Subform1![txtmemnbr])),(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]="&
Forms!frmMain!Subform1![txtempmemnumbera]) & " " &
DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]="&Forms!frmMain!Subform1![txtempmemnumbera])))--CiaoGeppo

 

[geppo]

Sorry geppo still getting syntax error?
Tony

Can someone tell me what's wrong with this rather complicated IIF
statement, I keep getting syntax error message.

This way if the criterions are type text

=IIf(IsNull[txtsubject],(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]='"
&Forms!frmMain!Subform1![txtmemnbr] &"'") & " " &
DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]=
'"&Forms!frmMain!Subform1![txtmemnbr]&"'")),(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]="&Forms!frmMain!Subform1![txtempmemnumbera]
&"'") & " " &
DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]="&Forms!frmMain!Subform1![txtempmemnumbera]
&"'")))> Thanks> TonyThis way if the criterions are type numerical
=IIf(IsNull[txtsubject],(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]=
'" &Forms!frmMain!Subform1![txtmemnbr]) & " " &
DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]=
'"&Forms!frmMain!Subform1![txtmemnbr])),(DLookUp("[txtfirstname]","[tblindividual]","[txtmemnumber]="&
Forms!frmMain!Subform1![txtempmemnumbera]) & " " &
DLookUp("[txtsurname]","[tblindividual]","[txtmemnumber]="&Forms!frmMain!Subform1![txtempmemnumbera])))--CiaoGeppo

you have to use the semicolons ( instead of the commas (,)

 

[John W. Vinson]

Can someone tell me what's wrong with this rather complicated IIF statement,
I keep getting syntax error message.

Well, let's break it down:

=IIf(IsNull[txtsubject],

Right there. IsNull is a function and needs parentheses to delimit its
argument:

IsNull([txtsubject])


John W. Vinson [MVP]

 

[geppo]

this way if the criterions are type numerical;


=IIf(IsNull([txtsubject]);DLookUp("[txtfirstname]";"[tblindividual]";"[txtmemnumber]="&
Forms!frmMain!Subform1![txtmemnbr]) & " " &
DLookUp("[txtsurname]";"[tblindividual]"; "[txtmemnumber]="&
Forms!frmMain!Subform1![txtmemnbr]);DLookUp("[txtfirstname]";"[tblindividual]";"[txtmemnumber]="&
Forms!frmMain!Subform1![txtempmemnumbera]) & " " &
DLookUp("[txtsurname]";"[tblindividual]";"[txtmemnumber]="&
Forms!frmMain!Subform1![txtempmemnumbera]))

 

[Tony Williams]

Thanks John
Tony

Can someone tell me what's wrong with this rather complicated IIF
statement,
I keep getting syntax error message.

Well, let's break it down:

=IIf(IsNull[txtsubject],

Right there. IsNull is a function and needs parentheses to delimit its
argument:

IsNull([txtsubject])


John W. Vinson [MVP]