Updating a Field Value From a Dialog

I am very new to Access. I have created a database in Access 2003. I
can enter the required record fields from a form. I would like to add
a feature that allows a user to update the "quantity" field (it is type
long integer). The update would be to add or subtract a user-entered
number to/from the current quantity. Perhaps a dialog would pop up on
entry to the quantity field. The user would enter a number and press
"Add" or "Subtract" to perform the desired action. Unfortunately, I
don't yet know how to make this happen.

As it is now, the user can change the quantity field but would have to
calculate the new value if he/she wanted to add or subtract to/from the
current quantity.

Thanks for any quidance you can give me on this.

Charles

.

Relevant Pages

  • Subtract from current value
    ... value in the database and store it in the same spot the value was. ... balance column in the database and the user makes a payment of 10.00. ... I want a query that will take the 10.00 and subtract it from the ...
    (comp.databases.ms-access)
  • Re: visualize activity on a website
    ... you subtract an arbritrary number of minutes from the ... current time and compare it to each. ... I usually store this information ... in a database table so that it is simple to query for just those who ...
    (comp.lang.javascript)
  • Re: Adding & Subtracting Numbers(Fields) with Expression Builder
    ... I simply want to add and subtract the fields to get a computed ... value in the query. ... the database) What is the exact syntax required for an computational ... Use the dot, not the bang. ...
    (microsoft.public.access.gettingstarted)
  • Re: anybody not use caculation
    ... i am not a acccess developer. ... this is only my second database, ... users to add and subtract it themselves before inputting into the database. ... data integrity and data validation, please hand the "Access Developer" hat to ...
    (microsoft.public.access.forms)