I have attached a db that opens to a form named frmModifiedAssignedEmploye
es. This form is based upon the table tblDesignatedEmployee and is structured as follows:
Designated EmployeeID (PK)
The purpose for this form is to allow employees to change assigned store employees. For example, Store X has been assigned a new District Manager and that record needs to be modified.
The first thing the user does is to select a store from a combo box called StoreID. Below this combo box are four unbounded and not enabled text boxes that receive information from the combo box that is informational only.
To the right of those text boxes are 4 toggles, each associated with an employee type. Currently I am only working on the first toggle District Manager. When the District Manager is toggled then the associated combo box is enabled and the user can then select from a list of employees to replace the current District Manager for that store. Thus the record is MODIFIED. I do not want to createa new record.
The attached db opens to the form I am referring to. StoreBonusRev.mdb