Hi
I am new to using Access 2000 and have created a database for stock control.
I would like to be able to order stock when the stock levels fall below a certain amount. I have a field called "stocklevel" and another field called "minimumlevel". When the stock level falls below or is equal to, than a pop up message displays telling you that you need to order some more goods. In the pop up message I would like to be able to have the option of opening up an order form to place an order or not to bother ordering any more of the product.
Can this problem be achieved on Access 2000 ?
Any help would be much appreciated.
Regards,
Midge.
I am new to using Access 2000 and have created a database for stock control.
I would like to be able to order stock when the stock levels fall below a certain amount. I have a field called "stocklevel" and another field called "minimumlevel". When the stock level falls below or is equal to, than a pop up message displays telling you that you need to order some more goods. In the pop up message I would like to be able to have the option of opening up an order form to place an order or not to bother ordering any more of the product.
Can this problem be achieved on Access 2000 ?
Any help would be much appreciated.
Regards,
Midge.
