Hi this is working:
=IIf(Forms!GARF!GARFsubForm![finished_good_#]<>"", DLookUp("[CustomerSKU]","ItemCustomerSKU", "ItemNumber = '" & Forms!GARF!GARFsubForm![finished_good_#] & "' AND Customer = '" & Forms!GARF![customer] & "' AND Company = '" & Forms!GARF![company] & "' AND MarketingSeason = '" & DLookUp("
=IIf(Forms!GARF!GARFsubForm![finished_good_#]<>"", DLookUp("[CustomerSKU]","ItemCustomerSKU", "ItemNumber = '" & Forms!GARF!GARFsubForm![finished_good_#] & "' AND Customer = '" & Forms!GARF![customer] & "' AND Company = '" & Forms!GARF![company] & "' AND MarketingSeason = '" & DLookUp("
Code:
","IDtoCode", "ID = " & Forms!GARF![season_id]) & "'"),"")
This is not working:
=IIf(Forms!GARF!GARFsubForm![finished_good_#]<>"", DLookUp("[CustomerSKU]","ItemCustomerSKU", "ItemNumber = '" & Forms!GARF!GARFsubForm![finished_good_#] & "' AND Customer = '" & Forms!GARF![customer] & "' AND Company = '" & Forms!GARF![company] & "' AND MarketingSeason = '" & DLookUp("[Code]","IDtoCode", "ID = " & Forms!GARF![season_id]) & "' AND Season = " & Forms!GARF![year]),"")
What am I doing wrong?