I have an order entry app that will also keep track of inventory stock quantities.

If a customer adds or deletes products in a typical order entry subform, how do I know what they added or deleted so I can update the inventory?

Is there a way to read each line of the subform so I can tell what is going on during an update or delete?

What is the best way to accomplish this?

Seems this would be easily accomplished using a trigger in SQL Server, but how is this done in an Access subform?

Try Rick Dobson, "Programming Microsoft ACCESS Version 2002", pg 501.
Regards Penta.

Add a date/time field that stamps when the action was taken. When a record is added, the current date and time (based on the user's computer clock) is stored.

For deletions, don't actually delete the record. Instead, mark or flag the record for deletion. If you use a checkbox for that, the date/time stamp would stamp the time the checkbox was clicked.

In the future, when you want to list all active (i.e. those records not marked for deletion) records in a report or listing in a form/subform, filter the report/form to only include those where the checkmark is unchecked (i.e. value FALSE).



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division