Thank youNEVER, run an update query that will update the current record.
ALWAYS save the current record before opening a different form or report or running any query.
Not sure how to handle this
When the product is selected from the drop down box, I need to have the Unit of measure updated to be able to do other calculations
If I can not update the UOM after the product has been selected, I a not sure how to get the UOM in place
I can not link the products table to have the UOM displayed because then the form wont be updatable
Not sure how to handle this one
Last edited: