I own a printing company. I am trying to write a program to keep track of our
paper in inventory. I set up a table and a form for adding inventory to the
database. I called the table "Instock". I am now trying to write a form to
reduce inventory. I set up a form that has a field for a lookup on an
incremental field called "Lot" in the instock table. When I select a lot from
a drop down list I want to be able to enter the number of sheets removed from
inventory and then update the "instock" table to reflect the changes. If at
any time I view the table or run a report I want it to reflect an accurate
amount of each type of paper and the location of it. I am having a
particularly tough time trying to define a button with some type of query
(probably a changeto) to update the instock table. Any ideas??
Ron Gutzky, 216-431-8400, rc...@aol.com