Question about populating combo boxes

[Ceichhorn]

So I have what I hope is a simple question: I have a combo box that people can populate in my access 2010 database (in this case, it is a list of services). This database is now many years old, and has a long list of services -- many of which are inactive and no longer provided.

I would like to "clean up" the combo box to only present the currently active services (I have created a field in my tblServices of ysnActive) when creating a new record. However, I'm aware that this will cause historical records to show that combo box blank if they have an inactive Service selected.

So my simple question: is there a way to get the best of both worlds? Have the combo box filter by only active services, but allow historical records to display inactive services if those records happen to be populated by them? Thanks in advance!

[aytee111]

You could add a textbox to display the value.