IIf and dlookup syntax

[AndycompanyZ]

I am trying to build a iif statement based on a dlookup to populate a filed on a form. So far I have:

 
= IIf((DLookUp( "[SubTeamHeadDelID]" ,"[tblSubTeam]","[Me]![SubTeamHeadDelID] =" &  [DelegateID]), [tblSubTeam]![SubTeamParentID] , [tblSubTeam]![SubTeamHeadDelID]))

But this gives an error that there are the wrong number of arguments. What I am trying to do is see firstly if the SubTeamHeadDelID is the same as the DelegateID on the form if so then put the SubTeamParentID into the box and if not put the SubTeamHeadDelID in the box. I have never combined a dlookup with an iif statement so I don't know even if this the correct way of doing it or even if it's possible. Any help would be most helpful thanks.

[Bob Fitz]

Hi

put the SubTeamParentID into the box and if not put the SubTeamHeadDelID in the box

Where are the true and false values (in blue). Are they on the Form, or are fields in a table called "[tblSubTeam]".

[AndycompanyZ]

They are on both actually. What I ultimately need to do is find the Ids and then have another textbox which will show the mobilenumber (which is stored on a delegate table) of the person to contact whether it belongs to SubTeamParentID or the SubTeamHeadDelID.

[Bob Fitz]

Hi

I'm not sure that this is what you need.
Please try it and post back with results.

= IIf((DLookUp("[SubTeamHeadDelID]" ,"[tblSubTeam]","[DelegateID] =" & Me]![SubTeamHeadDelID]), Me.[SubTeamParentID], Me.SubTeamHeadDelID]))