DLookup struggle

[Jan van Bekkum]

I want to make headers of columns in a report dependent of the language of the report. I have a control "AmountHeader". Dependent on the language it has to become "Amount" or "Bedrag". I created a table Translations with a.o. fields "AmountHeader" and "TranslationLanguage". The control [Language] is in the active form.

I have used all kind of variations of the string below in the Control Source of "AmountHeader", but I keep getting error messages or the wrong language.

=DLookUp("[AmountHeader]","Translations","[TranslationLanguage] =" & Forms![ProposalContentExternal]!Language)

The only one that worked correctly was:
=DLookup("AmountHeader", Translations","TranslationLanguage='Dutch'")

Has anyone a clue?

 

[pbaldy]

Note the syntax needed for a text value:

http://www.mvps.org/access/general/gen0018.htm

You supplied the single quotes when you hard coded a value.

 

[Jan van Bekkum]

Thanks a lot for the help!

 

[pbaldy]

No problem!