Please find attached Order subform we have developed from a query. The reason we want the user to enter codes and have the description come in automatically. We do not want the user to enter anything in But Code and Qty. Our Update Query is updating the Product Orders file, but our displays are showing incorrect data, becuase everytime the Order SubForm loads and a code is put in, the display available is doubling and giving waco results for available. We need to know a correct available for each product code after a sale is made.
We do not want the query that handles the order subform creating bad results. So we have our data correct in the product table each time a product is sold, but eroneous results occur when we try to enter additional records, becuase multiples are occuring.