using DLookup via a subform

[Kevin]

Hi,

access2002, xp

I've tried in about every variation I can compose -- so I must not be able
to refer to a subform using this function. Can anyone verify that that is
the case -- and if not, tell me where my syntax is kaflooey. Below are a
couple examples of my attempts.

=DLookUp("lastName","qryEvents_HPersons","eventID=Forms!frmEvents!zsfrmHPersonEvents!Controls!cboEvents(0)")

=DLookUp("lastName","qryEvents_HPersons","eventID=Forms!zsfrmHPersonEvents!cboEvents")

=DLookUp("lastName","qryEvents_HPersons","eventID=Forms!frmEvents!zsfrmHPersonEvents!cboEvents")

qryEvents_HPersons is an autolookup query -- where the joined field comes
from the many side. And then the query is used to feed a subform tied to
frmEvents joined by the eventID.

thanks

 

[ruralguy via AccessMonster.com]

Assuming eventID is numeric then:
=DLookUp("lastName","qryEvents_HPersons","eventID=" & Forms!frmEvents!
zsfrmHPersonEvents.FORM!cboEvents)

http://www.mvps.org/access/general/gen0018.htm
http://www.mvps.org/access/forms/frm0031.htm
http://support.microsoft.com/Default.aspx?kbid=209099