I've attached my db so you can better "see" what my objective is.
In the form frmBonusEarned I use 4 unbounded text controls that read from the combo box called StoreID. This form is my input form from which my calculations will be based upon.
Here's what can happen. An employee may no longer be an active employee and therefore would not be eligible for any store bonuses. In the table tblEmployee there is a Y/N field called Active. In my unbounded text controls I need to evaluate to see if the Employee is Active and if not the display some message such as "No Manager Assigned".