Changing the Row Source when the ComboBox GotFocus seems to have worked. Not as difficult as I feared. When the box GotFocus, change the row source to limit the list to active employees. When the box LostFocus, set the row source back.