Get current value and subtract access (1 Viewer)

Landon38

New member
Local time
Today, 18:42
Joined
Mar 29, 2017
Messages
1


So i have a table and design of this.

in the subinventory if i want to view first the stock input a subinventory on textbox then print on the other textbox w/e itemcode, itemdecs, subinventory, uom and requisition.

now if i want to order on subinventory textbox in the second i will put any numbers that will subtract to the current number in the itemdb and if the stock is lower than 100 it will show a msg box that the current stock is lower than 100, and if the stock is 0 it will show a msg that the stock is out of stock.

tyvm
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 10:42
Joined
Jul 9, 2003
Messages
16,224
It looks to me like you are asking a question about Microsoft Visual Basic in an MS Access forum. The tentative connection to MS Access is that you are storing information in an MS Access table, probably an *.mdb table. Baring that in mind, I think you are in the wrong forum. You might get a better response in a forum devoted to Visual Basic.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 10:42
Joined
Jul 9, 2003
Messages
16,224
Ah! I see... You posted this in a Visual Basic forum in AWF... I missed that! Didn't realise we had a VB forum.
 

Users who are viewing this thread

Top Bottom