display value not in combo box list

[TwoOdd]

I have a combobox with a list of values that the users can select. The users also have the ability to de-activate or remove items from that list to keep users from using that option on future records - the items will still exist in the source table of the combo box, they will wont be displayed in the combobox. When one of the de-activated values has been used on a previous record and a user goes to edit that record, not only does that de-activated value not show up on the list, it also does not show up in the box itself as a pre-selected value. Is there a way to show the value in the combobox as a pre-selected value but not allow the user to select it from list? Hope this makes sense.

Thanks in advance for any advice/suggestion/solution to this issue.

TwoOdd
--------------
Good judgment comes from experience, and experience comes from bad judgment.
-- Barry LePatner

 

[MajP]

here is a way to do this.

Build a combo using your "limited" query. Then build a textbox. Put the textbox overtop of the combo except for the down arrow. Send the Combo to back. I would lock the textbox forcing the users to choose from the combo.

Now the textbox will display what is in your query, but you can limit the rowsource of the combo.

You may want to post your sql for the combo if you are having trouble getting the textbox to display the related field in the table.