Dlookup expression.

[Perfac]

I have a few Dlookup expressions and they work correctly. I battle with one and don't see why. I have a table t01Payment, with Primary key field PmtID. Another field InvPchID01 keeps a reference to Inv no that is paid. In my PURCHASE INVOICE QUERY q02InvPurchase, I want to return the payment ID where InvPchID = InvPchID01.

My expression DLookUp("[PmtID]","q02Payment","[ InvPchID01]=" & [InvPchID]) returns the error "The object doesn't contain the automation object InvPchID01. I simply checked it over and over for spelling error.

[June7]

Is there really a space in "[ InvPchID01]" in your code?

You are doing lookup on a query, not the table. Are you sure the query has the field? Why don't you pull from table?