Help with DLookup

[shadowhawk]

Hello Access Community,

I am rather new to access and have a little problem while building a glossary.
I have a query which is called "QRY Glossary Data Item Process", it contains information about terms and meanings of words. The exact names for the columns are "Begriff (dt)"(=term) and "Definition (dt)"(=meaning).
I have built a new form ("Glossary") that forwards information about terms being used in another form ("SIPOC") in a list ("List8").
Now i want a text field to display information about the meaning which is taken out of the Query.

I am using the DLookup function but might be using it wrong.
=DLookup("[Definition (dt)]";"QRY Glossary Data Item Process";"[Begriff (dt)] LIKE
[Liste8]")



I always get the response #failure after starting the form and clicking on an item in the list.

I tried microsoft websites and other sites but they just don't help me.
Maybe you can help me with your experience.

Looking forward for interesting answers.

Greetings
shadowhawk

[CJ_London]

you should not use none alpha numeric characters in table and field names - it can confuse access on occasions, even if surrounded with square brackets

with regards your dlookup - it will only return one value so not sure the benefit of using like - you should use =. And since this is text needs to be surrounded with single quotes - try

....;"[Begriff (dt)]='" &
[Liste8] & "'")

[shadowhawk]

you should not use none alpha numeric characters in table and field names - it can confuse access on occasions, even if surrounded with square brackets

with regards your dlookup - it will only return one value so not sure the benefit of using like - you should use =. And since this is text needs to be surrounded with single quotes - try

....;"[Begriff (dt)]='" &
[Liste8] & "'")

Dear Ajax,

thank you so much for your solution! It functions now.

Greetings
shadow