populating a combobox

I have a table of names that populate a combo box on my form and it was working fine - when I need to remove a item from the combobox, I had a form to delete it.  But that causes problems for reports that needed to be able to show the old value so I added a field to the table of names to deactivate the name so could be set to not show but still be able to print in reports of history.

Now I need to be able to filter the combox contents on whether the item is  'active' or not
the active field is a boolean value or 1 or 0

I think this would be a valuable feature to add to your program,   if not, I will see if I can figure out how to do it with sql