I want to see if there is some kind of record in "technologia" field in table "tblDolZlecenia" where "technologia" = 1 and where tblDolZlecenia.id_zlecenia = forms!frmZlecenieMarzena!id_zlecenia (id_zlecenia is a text field)
So I built DLookUp, the problem is, that two criteria won't work together but separately working good.
Does anyone know why is that?
So I built DLookUp, the problem is, that two criteria won't work together but separately working good.
Code:
Nz(DLookup("[technologia]", "tblDolZlecenia", "[Id_zlecenia]='" & Forms![frmZlecenieMarzena]![ID_Zlecenia] & "'" And "[technologia] = 1"), 0)