Hi Access expert! I was following Richard's "Customer-Specific Product Pricing for your Microsoft Access Order Entry Invoicing System" on YouTube because I want my invoice to automatically lookup the different price of a same product based on the Customer ID. However, I encountered an error when creating DLookup in the query that I could not resolved.

This is the expression:

PriceUSD: DLookUp("CustomPrice","CustomPricingT","CustomerID=" & [Forms]![CustomerF]![CustomerID] & " AND ProductID=" & [ProductID])

These are all the fields in CustomPricingT :

CustomPricingID
CustomerID
ProductID
CustomPrice

The major different I found between Richard's data and mine is that my CustomerID (in both CustomerT and CustomPricingT) is in short text e.g. WBC, whereas Richard's example is in Autonumber.

When I clicked RUN, an Enter Parameter Variable box would always popped up, within it it said Forms!CustomerF!CustomerID and I have to input something. I then tried input one of my clients' ID e.g. WBC, it returned me this error: The expression you entered as a query parameter produced this error: 'The object doesn't contain the Automation object 'WBC'

Already I'd been trying to resolve this error myself for a few hours but in vain.

Help is much much appreciated, thank you!