Dlookup issue

[Tark221]

Hi everyone,

I'm using a Dlookup in expression builder and it's only returning the value of the first record rather than the criteria I specify. Has anyone come across this issue before? Could someone give me an example of a dlookup.

Thank you

 

[Tark221]

Hi,

Thanks for the quick reply

im using this in the control source in properties, this is tied to a textbox

=DLookUp("[STAFF_AREA]","[RAW]","[REFERENCE_NUMBER]=[tbID]")

 

[AlexHedley]

Is [REFERENCE_NUMBER] the Primary Key or a unique number in the Table?

 

[pr2-eugin]

Sure that was a typo Pat..

=DLookUp("[STAFF_AREA]","[RAW]","[REFERENCE_NUMBER][COLOR=Red][B]= " & tbID)[/B][/COLOR]