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