Access MICROSOFT ACCESS -- Combo box help

[allin1joe]

I have a combo box based on the following:

Select ID, Name from Table Where ACTIVE_YN = "Y"
Bound column 1
Display width 0,1

Now, if the value deactivates, I would still like any records that have that value assigned to it to show correctly (I just don't want users to be able to set any other records to that value). I understand that I can't use Limit To List since I'm displaying a different column than I am bound to. Do I have any other options?

Thanks

Joe