Hi,



It is possible in Access whereby, I have 2 form. The first form user key in the baseline value of a field. Second form would be the main form where all data is enter and also where all calculation is done. (Is hard to explain so i show the example below.)

Form 1:

Item A value I set it as 100 (This is the minimun balance of the Item A)

Form 2:

User type in all the transaction for Item A where User receive 1000 Item A n slowly withdraw Item A until Item A reach 100 or below. Then a message would prompt out to say that is time to Re-Order Item A again.

Which mean the balance calculate in form 2 will always compare with the baseline value i type in form 1. Can it be done...??
Need some guide and help. Thank.