I have 1 form, it is bound to a REPAIRS table. This table has the fields Product (primary key) Date, NumberUsed. I have a unbound combo box that looks up a product from a PRODUCTS table. I want to select the product, and save a record in the table the form is bound to, REPAIRS. I also want to have a command button that runs an update query on the products table that decrements a field called INSTOCK for that particular product. I am brand new to access and have been trying to do this for 2 days- now I have myself totally confused. Any help would certainly be appreciated. Thank you in advance.