Code Desc Current
1 Item 1 yes
2 Item 2 yes
3 Item 3 no
4 Item 4 yes
Code is obviously the bound column, Desc is what is displayed and current indicates it is currently valid option.
I want to be able to limit my list to display only item's 1,2 and 4 (this bit is easy). However if i load a record which has had 3 selected in the past, I want display item 3, even tho it isn't in the list. If a user wishes to change from item 3 they should see only the current options (1,2 & 4).
What if i set the combo box to unbound, limit to list. On change set the bound column...that could work... I would just need to include the lookup table in the forms recordset to include the description.