June
In post 8, the OP stated that
CmbEnt_ID04 is the field in query q02InvPurchaseSub and IntItmID the field in query q02InventoryItem that should be the same
If it's a number field then it should be:
Code:
LatestPrice: DLookUp("[UnitPrice05]","q02InvPurchaseSub","DocumentDate01=Dmax('Docume ntDate01','q02InvPurchaseSub','[CmbEnt_ID04]=' & [IntItmID])")
I'm assuming that single quotes will work here as its inside an existing DLookup expression ... though I've not tested it
However, as already stated using two domain functions in a query field is a bad idea.
ajax provided a better solution in post 11