Dlook up is failing with queries

[MilaK]

Hello,

I'm trying to look-up calculated field "items" from "qrysamplecount" query and display it in another query "qryProjectDlookup". I'm not sure why it's not working.

The first query is called "qrysamplecount" and returns the number of samples for each project and the main query is called "qryProjectDlookup".

I'm using Dlookup instead of connecting the two queries because I plan to use this query a row source that can be modified by the user.

An example is attached.

Thank you for you help,

Mila

 

[sneuberg]

The qualifier [qrysamplecount] doesn't make sense. Try

Samplecount: DLookUp("[Items]","[qrysamplecount]","[run_name]= '" & [run_name] & "'")

instead of

Samplecount: DLookUp("[Items]","[qrysamplecount]","[run_name]= '" & [qrysamplecount]![run_name] & "'")