Syntax error

[mapat]

Hello, I have the following on the control source of a text field:
=IIf([pcSSISSA]=True,DLookUp("[Reason]","[MissingFormReasons]","[ID]"="[pcSSISSAtext]"))

being:
[pcSSISSAtext] an integer
[ID] an integer

it is giving me an error, what would be the right syntax?

Thank you

 

[JANR]

Try and remove the quotes marked RED

=IIf([pcSSISSA]=True,DLookUp("[Reason]","[MissingFormReasons]","[ID][COLOR=red]"[/COLOR]=[COLOR=black]"[/COLOR][pcSSISSAtext][COLOR=red]"[/COLOR]))

JR

Edit: missing a "&" try this:

=IIf([pcSSISSA]=True,DLookUp("[Reason]","[MissingFormReasons]","[ID]=" & [pcSSISSAtext]))

 

[KathyL]

I think you’re missing the 3rd argument. You have no argument for the False situation.
Your Dlookup is your 2nd argument.

 

[mapat]

I added the 3rd argument to the iif function, and have tried deleting the red quotes and have tried different combinations and is still not working. Any other ideas?

Thanks

 

[JANR]

Does it look anything like this now?

=IIf([pcSSISSA]= True, DLookUp("[Reason]","[MissingFormReasons]","[ID]=" & [pcSSISSAtext]), "false Argument")

- What is pcSSISSA, is it a true/false control on your form?

JR