I WANTED TO KNOW WHAT I AM TRYING TO DO IS POSSIBLE OR NOT. OPEN THE ZIP THERE IS AN INVENTORY TABLE AND FORM ETC. WHEN YOU CLICK MAIL ORDER DATA AND FILL OUT THE FORM YOU CLICK SUBTRACT FROM INVENTORY. THIS SHOULD AUTOMATICALLY SUBTRACT FROM INVENTORY AND PUT THE SUBTRACTED NUMBER INTO THE (ALLOCATED TO ORDERS) FIELD IN THE INVENTORY TABLE . FROM THERE I CAN GET THE 30, 90 YEAR TO DATE AVERAGE. I HOPE OR THAT IS THE THEORY. IN CASE I DID NOT MENTION THIS BEFORE I AM A ROOKIE AND TRYING VERY HARD TO UNDERSTAND THIS. I HAVE BOUGHT SEVERAL BOOKS, LIKE VB 6.0 AND ACCESS 97 TROUBLE SHOOTING. BUT I AM STILL LEARNING. ANY HELP IS GREATLY APPRECIATED.
THANK YOU AGAIN!!!

The code behind the button calls a query, "QRYSUBUPDATE" that does not exist in the database window