dlookup runtime error 2001

J

Jon D.

I have a products table with fields ProductID,
Description,Price. I also have an order details table
with fields orderID, ProductID,UnitPrice. My afterupdate
code to lookup price value for orderDetails.UnitPrice
looks like this: Dim strfilter as string
strfilter="productID=" & me.productID
me.unitPrice=dlookup("price","products",Strfilter)_
end sub

I am getting run time error 2001 previous operation
canceled. Please help

Thanks, Jon
 
Top