Continuous Forms DLook Up

[Costefran]

Can anyone help with the following

I have a a form set to continuous forms where the value of one control on each record should be set using a unique reference for each record.

When one control produces the results, all controls on all records show the result even though they should not

I have entered the control source for the control hoping that this may help

I assume the control needs to know what record it is in but not sure if or how I can do this

=DLookUp("[Clash Count]","Works Clash Pre Final6","[Reference] = Forms![Works Clash Pre Final2B for Subform]![Reference]")

 

[MajP]

When one control produces the results, all controls on all records show the result even though they should not

Actually the way you have that set up it is doing exactly what it should

you probably want something like

"[Reference] = " & [Reference]

 

[Costefran]

Thanks