Dropdown List values different from bound field values

[jharding08]

I have a dropdown that lists employees but only active employees (where inactive=FALSE). The dropdown is also bound to a table that stores the employeeID per record and has historical data (Inactive=TRUE or FALSE.)

I am seeing that when an employee is set to false, it doesnt show in the dropdown list, which is correct, but also doesnt show in the bound dropdown field. I dont have any criteria to filter it out in the form and the form recordset shows the value

Is there a property in the dropdown that controls this?

 

[theDBguy]

Is there a property in the dropdown that controls this?

There is, but it never worked, or I don't understand what it's supposed to do. There are a couple of workarounds for this issue.

 

[jharding08]

I'm guessing using the dropdown and a bound textbox and an afterupdate event ?

 

[theDBguy]

I'm guessing using the dropdown and a bound textbox and an afterupdate event ?

Would be one approach. Another is to not filter the dropdown but just sort it to move all inactive to the bottom.