i have a form (frmNationalPrices)
a unbound cbo is used to select a product.(tblPricesProducts
this feeds a subfrm to display a datasheet of suppliers who have submitted a price (tblPricesItemRetailPrice)
On the same form i enter some data and end up with a new price in a unbound txtbox(txtCaculatedPrice)
please help with how on a event like a button press i can update a single price from the prices tbl.
i can run a select qry to display the correct row but can not find a way to update it without reentering the price.
Thanks for your help
i have attached the sql used to selected the prices.
SELECT qrySubSuppPrices.pricesID, qrySubSuppPrices.tblPricesProductsID, qrySubSuppPrices.tblPricesSupplierID, qrySubSuppPrices.tblSupplierName, qrySubSuppPrices.tblPricesItemRetailPrice