up dating data

[gft]

hello,
I need to create a simple db to enter and update data. One table with two fields one will have the unique codes that i will have pre entered and one with quantities.


In a form I will type the unique code and then the quantinty, every time I enter a quantity the field will be updated. For example I type code 701 quantity 1 click on a button and it should update the quantity of code 701 to 1. The next time I type code 701 and quantinty 3 it should update the quantity to 4. I hope I make sense and thank you in advance. Regards George

[ranman256]

make a form, put 2 text boxes on it; txtCode, and txtQty
(better would be combo box for Code and just pick from it)

create an update query,quAddNewQty
it will add the items on the form..
quAddNewQty: update table set [qty] = [qty]+forms!myform!txtQty where [code]=forms!myForm!txtCode

the updatebutton will run the query:
docmd.openquery "quAddNewQty"

[ssanfu]

Welcome to the forum, George.

It sounds like you are very new to Access. I think it would help you by doing these tutorials. Not just look at them, actually do them.
http://www.rogersaccesslibrary.com/forum/forum46.html

Good luck with your project....