I a just starting to use ms/access 2010 and have a small db wuth 3 tables: [beneficiario], [ordempagamento] and [projetos].
I am trying to build a form for [ordempagamento] that, from an input code (a name) would retrieve an address from [beneficiario].
So I am using the following sysntax:
= Dlookup ("Morada";"Beneficiarios";
"Nome =" & [FormNomeBeneficiario])
It would not work, yelding #error as a return
= Dlookup ("[Morada]";"[Beneficiario
] =" & [FormNomeBeneficiario])
could nor pit to work
I am attachiing the database
can anyone help? formulariosFEDON.accdb