Update form field with query results

[seeya]

Hi,



I would like my form frmCampaigns to look up a field Press Release from a query qryPressReleases where Activity ID is the common identifier on both form and query.

Activity ID is a short text.
Press Release is a numerical value.

On frmCampaigns > Press Release Field Property Sheet > Control Source, I've inserted below but it keeps returning an error. Any ideas what I'm doing wrong?

=DLookUp("Press Release","qryPressReleases","Activity ID = " & Nz("Activity ID",0))

Thanks in advance
Seeya

[ranman256]

You don't need the NZ, if ID is a key.
keys can never be null.
BUT you said it was a string so it must have quotes....

Dlookup("[field]","query","[id]=' " & me.id & "'")

fields with spaces In the name must have brackets around them.

[seeya]

You don't need the NZ, if ID is a key.
keys can never be null.
BUT you said it was a string so it must have quotes....

Dlookup("[field]","query","[id]=' " & me.id & "'")

fields with spaces In the name must have brackets around them.

Thanks ranman256. I managed to get it to work!

=DLookUp("[Press Release]","qryPressReleases","[Activity ID] = '" & [Forms]![frmCampaigns]![Activity ID] & "'")

Now I've another problem! The value doesn't get updated in my table..which is tblCampaigns. What am I missing again??