Form button to add value in table

[Niyrho]

I have a table with a list of things in it, including a field for quantity.



I have a form to add new objects to the table.

In the same form I can select an object already listed in the table.

I need to add a textbox I can enter a number into and a button that, when pressed, will add the number in the textbox to the quantity for the selected object in the table.

Can Access even do this?

[June7]

Sounds like you are trying to maintain a 'quantity on hand' value. It can certainly be done but should you? Review http://allenbrowne.com/AppInventory.html

[ranman256]

Can’t you just type in the value? Why a button?

[Niyrho]

Can’t you just type in the value? Why a button?

I have to track quantities that range from ounces to hundredths of grams.

[Niyrho]

Sounds like you are trying to maintain a 'quantity on hand' value. It can certainly be done but should you? Review http://allenbrowne.com/AppInventory.html

Yes, I should because it's what I need it to do and part of the purpose of a database.

[June7]

Yes, purpose of database is to store and manage data. However, it is usually bad design to save aggregate data, especially if there are no records to substantiate the saved value. What if person accidentally hits the "Add" button more than once for the same input? How would that error be discovered? Better practice is to calculate summary data from transaction records.