Not sure what error this is (1 Viewer)

You need to change the line
Code:
Price = Nz(DLookup([Price], [OrderDetailsQ], "ProductDetailsID=" & Me.ProductCmb), 0)
in the following
Code:
Price = Nz(DLookup("[Price]", "[OrderDetailsQ]", "ProductDetailsID=" & Me.ProductCmb), 0)
I'm not sure but you might also need spaces before and after the equals sign in these expressions. I probably add spaces in SQL expressions where I don't need them, but I know for sure there are some places where you do need to have them.
 

Users who are viewing this thread

Back
Top Bottom