+1 to table value

[Master Klick]

That works for me. You're method worked, it was simple, to the point and idiot proof. I learn more getting to the point and clean info like that too. Now I have something else to pick apart and see what each thing in the code actually does. You helped with one thing but I'll end up using that info in 50 different ways. Thank you.

[Dal Jeanis]

Okay, here's an assignment then. Suppose that you had a text box called txtNewQuant that had a new value to replace the old quantity, and the command button was called cmdSetQuant. What would the VBA behind the onClick event of cmdSetQuant look like?

Can you get that working?

Quick notes - remember that & is an operator that concatenates the strings on either side of it, and _ (underscore) at the end of a line is a continuation character.

If you get the basic code together, then I'll follow up and throw in all the error checking code you'd normally want.