Reorder Stock code

[AdilSaumtally]

I am currently trying to figure out a code to order in more stock (reorder amount) when stock reaches its 'reorder level' but do not know where to start.
If this has made you confused please look at the picture below.
Also, is there a more sofisticated code to use rather than just IF?

[Kelly Armstrong]

I am assuming that you need to have different reorder levels for different items.

One option would be to create a table with the minimum inventory amounts for the different items (this could also be added to an existing table), then run a query finding the items that are below that amount (you should include the SQL in the vba code), then using an If statement you could use vba code to have a message box appear instructing the user to reorder for all items that are below the reorder amount. This code could run every time an order was placed for an item, then the reorder message box would pop up every time an order was placed until the item was reordered. I believe that this would be the easiest way.

The other option that I see would be use Case statements. However, it would categorize everything. For instance, you could have the code pull everything that has 8 to 15 of an item and code a message box to say "inventory critically low. Reorder advised." Then all items with inventory 0 to 7 you could code a message to say "Inventory stock depleted, must reorder".

Anyone have anything else to add?