Changing value in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I am building a database with an inventory table. I want to adjust inventory level every time a new order is place
(shows up in the new orders table)
i've tried a macro but can't seem to get the inventory level to update.
 
Lynn
yes, I enter order data in a new orders form similar to the Northwind form. I've tried several ideas but not being an Access guru makes it difficult.
 
Chuck,
You are not going to be able to do this with a simple macro. You will need
to write some VBA code to accomplish it. Without knowing the exact layout of
your tables, it won't be easy to give you much more than a general break
down of the steps.

1. Add code to the BeforeUpdate event of your new orders form.
2. Include a call to a query that gets the current inventory level from
your inventory table.
3. Subtract the order amount from the current inventory level.
4. Call an update query that sets the value in the inventory table to the
value just calculated in step 3.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Chuck in Phoenix said:
Lynn,
yes, I enter order data in a new orders form similar to the Northwind
Click to expand...
form. I've tried several ideas but not being an Access guru makes it
difficult.
 
Thanks Lynn. I kinda thought I'd need a macro...but thought it would be AfterUpdate. I'll try both.
 
You might be able to use AfterUpdate for that, but you have less control
than you do with BeforeUpdate. If something goes wrong you can set the
Cancel paremeter in BeforeUpdate to True and stop the processing.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Chuck in Phoenix said:
Thanks Lynn. I kinda thought I'd need a macro...but thought it would be
Click to expand...
AfterUpdate. I'll try both.
 
Back
Top