help with dlookup on control source on property sheet

[davyre]

Hi,
I need help with using DlookUp on control source of a textbox in a report.

dlookup([POnumber],"TblCustOrder",[CustomerID]=CustomerID)

What I'm trying to do is to grab the PONumber from TblCustOrder Where CustomerID equals to CustomerID from a query that is used as Record Source of that Report.

Any help? Thanks!

 

[davyre]

this does not work either

=DLookUp([TblCustOrder]![PONumber],[TblCustOrder],[TblCustOrder]![CustomerID]=[TryQueryStatus]![CustomerID])

 

[dhookom]

Why not add tblCustOrder to the report's record source?

If CustomerID is numeric and the field is in the report's record source, try:

=DLookup("[POnumber]","TblCustOrder","[CustomerID]=" & [CustomerID])

Duane
Hook'D on Access
MS Access MVP