Requery Question

[ecupirate]

I have a combox (cboDept) which filters another(cboEmployee) on my form. On AfterUpdate of my "cboDept" I have Forms!frmEdit!cboSelect.Requery which works and gives me my employees for the Dept selected. My problem is that the first employee listed after requery remains even if I select another dept. Example: if I select Dept: retail loan doc I get Jane Dave Bob. If select Jane, but decide to go back and select another department Jane will still appear at the top of the list even though Jane does not belong in that department. I need to empty Jane out of the query..

 

[ecupirate]

Figured it out.Thanks