I have a small database and, in a form, I do need to obtain a value in a table that dependes on the combination of 2 entries.
I am using the Dlookup funcion as per below:
o]='" & [FormCodigoProjetoFED] & "'" And "[NomeBeneficiario]='" & [FormNomeBeneficiario] & "'")
and I am using this for 3 fields in the form as I need to obtain 3 different values.
However, in the form, I am consistently getting , for the first field, a wrong return, and for the other, it is returing "#error"
I am attaching the database
can anyone help me? formulariosFEDON.accdb