"Hide" combo box items

[Niek]

Hello,

I have a combo box with a list of user names. The data source of the list is a table, tblUsers, and the property "Limit to list" is set to Yes, in order to avoid anything other than valid users to be entered. Over time, some users will become "inactive", e.g. leave the company. Now I would like to have a way to remove/hide these users from the combo box, without causing conflicts in the existing table. In other words, it should not be possible anymore to select an inactive user name from the list, but the existing records should remain unchanged. Any suggestions?

Niek

 

[John Big Booty]

Could you add a check box to your employee table, and uncheck that when an employee leaves, you could then filter out those employees in the Combo's Row Source.

 

[Niek]

Thanks for the answer! I was thinking something like that as well, but wouldn't that give conflicts with the existing entries for users that become inactivated, because of the "Limit to list" property?

 

[John Big Booty]

What might need to do, is have a dynamic Row Source for your combo. For new records you use the filtered row source, then on the old records you lock the Combo and use a Row Source that shows all records.

The sample here may give you some pointers.