I have a form that has two controls for name and employee#. The user picks the name from the dropdown box, which fills in the employee# and other information in the subform (address, ph#'s, work schedule).
The user then needs to pick from another dropdown box in the subform, and if they pick...