>How can I set up a combobox so that when adding new records to an input form, it will only display choices which are "active" in the choice table, but when viewing old records in the form, it will need to display the value of the choice, even if that choice is now disabled?
>
>The fields in the Choices table are:
>
>status ('A' for Active or 'I' for Inactive)
>id
>description
>
>Choices.id is the bound column, and it is bound to an 'id' field in the LineItems table.


I just do a SQL - SELECT like

select description,id from choices where status='A' or id=mycurrentrecord.id