>>I just do a SQL - SELECT like
>>
>>select description,id from choices where status='A' or id=mycurrentrecord.id
>
>Indeed! This is a perfect solution. For ALL these years, that idea had never occurred to me. It took about 3 lines of code to implement (done as my record pointer is moved).
>
>I'm ashamed to say what I was previously doing to handle this.
The simple solutions are the most gratifying for sure. Glad I could help.
Brandon Harker
Sebae Data Solutions