I tried entering the code following your logic but I am receiving an error. The error is "Compile Error: Member or data member not found", and it is highlighting my me.cboSelectProduct in blue. Here is the code i have typed. In my inventory table i have my primary key as productid which is a lookup field referencing another table for description. I then set each of my products to a quantity of zero in the inventory table.

what should the "me" be replaced with? Also, should i replace the bracket, or just the names within the brackets. I did go through and replace the variables accordingly I thought. For example, my combo box i renamed SelectProduct and my text box is named Quantity.

I went through and made some changes and didnt get the compile error. However, when i enter my information (choose a product, then enter a quantity and click the process button) it pops up with an "enter parameter" dialogue box, and then says 0 rows will be updated, to proceed hit enter.

Any ideas?? Also, what does it mean when it asks to enter a parameter value?

me. should stay as it is. You need to add the correct form control names after it

you can leave the square brackets, but field and table names must match those in your db, including any spaces. For example, you mention you have a field called "productid", but when i look at your code it refers to a field called "product id" (with a psace) - an entirely different animal.

The variables you can call whatever you like as long as you're consistent about where you use them

I did everything, and found one minor error when i was adapting your code to my field names. Thank you very much by the way for that code.

Now it compiles but when i select a product on the form via the combo box, enter a quantity into the text field, and hit the process button i get an error saying : "Run time error 2001 You cancelled the previous operation"