Dlookup

[Claudette Hennessy]

=DLookUp("[Bldg] & ' ' & [BoothNum]","tblEvent","ShowID = 1 and ShopID = "
& Forms!frmContractUpdate!cboShopID)

I am getting wrong values for the case that the where clause is not
satisfied(I seem to remember Dlookup does this); I want to write
IIF( no case where a record satifies the conditions,"nodata",DLookUp("[Bldg]
& ' ' & [BoothNum]","tblEvent","ShowID = 1 and ShopID = " &
Forms!frmContractUpdate!cboShopID))
How do I do this?
Thank you in advance
Claudette Hennessy

 

[Tom Lake]

=DLookUp("[Bldg] & ' ' & [BoothNum]","tblEvent","ShowID = 1 and ShopID =
" & Forms!frmContractUpdate!cboShopID)

I am getting wrong values for the case that the where clause is not
satisfied(I seem to remember Dlookup does this); I want to write
IIF( no case where a record satifies the
conditions,"nodata",DLookUp("[Bldg] & ' ' &
[BoothNum]","tblEvent","ShowID = 1 and ShopID = " &
Forms!frmContractUpdate!cboShopID))
How do I do this?
Thank you in advance
Claudette Hennessy

You could try this:

=IIf(IsNull(DLookUp("[Bldg] & ' ' & [BoothNum]", "tblEvent","ShowID = 1
and ShopID = "
& Forms!frmContractUpdate!cboShopID), "No Data", DLookUp("[Bldg] & ' ' &
[BoothNum]", "tblEvent", "ShowID = 1 and ShopID = "
& Forms!frmContractUpdate!cboShopID))

Tom Lake

 

[Claudette Hennessy]

Thank you very much, I had some mistake in the syntax and couldn't find it.
This works after I put one more ")" in the expression, ie
=IIf(IsNull(DLookUp("[Bldg] & ' ' & [BoothNum]", "tblEvent","ShowID = 1
and ShopID = "
& Forms!frmContractUpdate!cboShopID)), "No Data", DLookUp("[Bldg] & ' ' &
[BoothNum]", "tblEvent", "ShowID = 1 and ShopID = "
& Forms!frmContractUpdate!cboShopID))
Claudette

=DLookUp("[Bldg] & ' ' & [BoothNum]","tblEvent","ShowID = 1 and ShopID
= " & Forms!frmContractUpdate!cboShopID)

I am getting wrong values for the case that the where clause is not
satisfied(I seem to remember Dlookup does this); I want to write
IIF( no case where a record satifies the
conditions,"nodata",DLookUp("[Bldg] & ' ' &
[BoothNum]","tblEvent","ShowID = 1 and ShopID = " &
Forms!frmContractUpdate!cboShopID))
How do I do this?
Thank you in advance
Claudette Hennessy

You could try this:

=IIf(IsNull(DLookUp("[Bldg] & ' ' & [BoothNum]", "tblEvent","ShowID = 1
and ShopID = "
& Forms!frmContractUpdate!cboShopID), "No Data", DLookUp("[Bldg] & ' ' &
[BoothNum]", "tblEvent", "ShowID = 1 and ShopID = "
& Forms!frmContractUpdate!cboShopID))

Tom Lake