Hi there
I try to make a Dlookup in a form in order to get a query record
As follow
=Dlookup("[prix_token_reeval]","Reevaluations_Last","[adresse_reeval] = " & [Formulaires]![Ajout_Reevaluations]![liste_adresse])
record I am looking for Query field to be check with combo list in form
The adress field from query should be equal adress selected in a combo list on the form
But I get #error in my control, I can not understand why.
Is somebody can help me to tell me what wrong ?
Thank you
Chris
I try to make a Dlookup in a form in order to get a query record
As follow
=Dlookup("[prix_token_reeval]","Reevaluations_Last","[adresse_reeval] = " & [Formulaires]![Ajout_Reevaluations]![liste_adresse])
record I am looking for Query field to be check with combo list in form
The adress field from query should be equal adress selected in a combo list on the form
But I get #error in my control, I can not understand why.
Is somebody can help me to tell me what wrong ?
Thank you
Chris