Using DLookup in an IIF statement

[BradCollins]

I am trying to utilise the following code, I have tried a few things, but nothing seems to work.

IIf(DLookUp("[fldSiteNumber]","tblSettings")="",([tblTank_Details].[fldDepot]) Like "*",DLookUp("[fldSiteNumber]","tblSettings"))

Basically I want to restrict a search by the site number, so taht users only see their own data, and then if you are at head office show all the data.

I have tried changing :

IIf(DLookUp("[fldSiteNumber]","tblSettings")=""
to
IIf(DLookUp("[fldSiteNumber]","tblSettings")is null

and a few other things, but cannot seem to get this to work.

Any ideas would be most appreciated. Thanks

 

[BradCollins]

Doesnt matter, I have finally worked it out.

If any one is interested, the solution is:

IIf(IsNull(DLookUp("[fldSiteNumber]","tblSettings"))=True,([tblTank_Details].[fldDepot]),DLookUp("[fldSiteNumber]","tblSettings"))