Access VBA code in report gives the same result for each row

Question

This is my report:

I have coded in VBA so that the 3rd column (texbox) shows the ID related to each MinDeNote.
But it just shows 3 for all row.
3 is the ID of the first product, not all of them.
How could I do to make a loop? Thanks !

This is my code:

Me!Texte7 = DLookup("F_Code", "Query", "Note = """ & [MinDeNoteBox] & """")

The outcome is gonna be different for each row, which is not the case now.

Answer 1

等待大神答复