Combo Box control - Add new items but don't display on list

[MeisoT]

I just posted another question on combo boxes, but think there may be a different response to this one - so I'm posting separate questions to keep the responses separate.

How do you add an item to a field that uses a combo box control without displaying the data on the visible drop-down list. I do not want some of the entries to be available for selection, but want them entered into the field anyway. Is this possible?

Access Version = 2000

Thanks.

 

[Remou]

I guess the easiest would be an additional field that flagged whether or not to display the row. You could then set the combo box to select where display is true.

 

[MeisoT]

I tried this Remou. The problem is that if the data does not display as an item on the drop-down list, it also won't display in the text portion of the combo box. I want the data to display in the text portion of the combo box when a user views the record, but I don't want the data to be a selectable item on the drop-down list. Is this impossible?

 

[Remou]

Yes, I only saw your other post after replying, so I will refer you to that post, to see if the idea there suits. Another method would be to use the Before Update event to cancel with a warning if the user selects an ex-manager.

 

[MeisoT]

Thanks Remou. Using the Before Update event will definately solve the problem. I'm just surprised that Microsoft has not provided a built-in way to handle this scenario, which seems to be something that is quite common when dealing with active/inactive employees.