Hi, I am having problems to figure out the correct sintax for my lookup field.

I have the following table called SottobudgetT with the following fields

IDSottobudget (primaryKey)
IDGrant (numeric)
IDAnnuality (numeric)
IDExpenseCategory (numeric)
Sottobudget (numeric)

In another form I am using the Dlookup function to get the sottobudget, but it depends on the IDGrant, IDAnnuality and IDExpenseCategory (which are combo boxes)

This is what I wrote, but it is obviously wrong as it just returns the first Sottobudget (like there is no criteria)

Dlookup = ("Sottobudget","SottobudgetT", "IDGrant=" & [cboGrant] AND "IDAnnuality=" & [cboAnno] AND "IDExpenseCategory = " & [cboExpCat])

Can anybody help?

Thanks