Hello,

I am seeking advice on a small app I am working on. It is a small inventory management program in which I have embedded an Access
database into. What I am wondering is, are there any ways to reference a change in a record of a database. For example, if the inventory of an item changes from 2 to 0, then I want to re-order more. But, I am not sure if it is possible to reference this change in value.

I know that you can literally drag the fields into the form and it will create text boxes - but I wanted to leave it embedded as a database and reference it that way.

If you know of any ways to do this, that would be great!

Anthony