I have two tables that I keep track product sales. Firs table [TblProduct] has these fields. ProdID, ProdName, ProdDate, ProdPrice. and ProdID is the key. The second table [TblProdSales] is where I enter product sales and it has these fields. SaleDate, ProdID, ProdQty, ProdPrice. Also I use form to enter product sales and the form has these fields. SaleDate, ProdID, ProdQty and ProdPrice. ProdPrice in the form I'm using Dlookup and here is where I have the problem =Dlookup("[ProdPrice]","TblProduct","ProdID="&[ProdID]).
Here is the problem the field ProdPrice some times I'm getting the right price and sometimes it is coming error, also if I enter wrong product and i go up to change the product id the price is not changing. Please note I'm using continuous form if it makes different. Thanks
Here is the problem the field ProdPrice some times I'm getting the right price and sometimes it is coming error, also if I enter wrong product and i go up to change the product id the price is not changing. Please note I'm using continuous form if it makes different. Thanks
