Dlookup Not Working

[abbaddon223]

Hi,

I'm hoping someone can help please? I'm trying to get a Dlookup working and I'm not sure if it's the syntax or the source table (in this case a select query).

[Script_Lookup] = DLookup("Script", "Slc_Campaign_Scripts", "ID='" & lead_id & "'")

I'm trying to get the dlookup about to pull through the value from a select query (the value being the text in script) with the qualifyer being lead_id on a form

It's worth highlighting that the value I am trying to lookup is a memo field and the control the value is going into is an unbound memo field.

The ID and lead_ID fields are text.

Any help appreciated!!

 

[Poppa Smurf]

If you are using a select query the format for the field in the query should be
Script_Lookup: DLookup("Script", "Slc_Campaign_Scripts", "ID='" & lead_id & "'")

 

[abbaddon223]

You nailed it - thank you very much for your help!