>>
>>Don't use the same query file to do the look ups or relationship in your other display.
>
>
>It's only one display. The thing is the ControlSource can't find the name in the drop down list so it doesn't display it in the collapsed drop down. It needs to be there at all times but only allow selection of the active ones.
>
>
>>What I have started to do is make all my combo boxes as a type 0. I then build them from my cursors using addlistitem. I do this because I have a data environment object attached to the list box so it loads it's own cursor. This is good for codes. The problem was though, the same code table is used for diffent drop downs (each with it own parameter) and the last select seemed to populate all the lists. With addlistitem, I build each list individually. You could do the same thing, and in your base class, exclude adding any item where the active flag was false.
>
>
>I might play with this after I try Jim's suggestion which is similar to yours
>
>
>>By the way, I am going to bring my PC on Wednesday for the demo and discussion.
>
>
>Please do or you will have a hard time doing your demo < G >.
>BTW, did you get an e-mail about the meeting? I think the mail server might be down again.
>

I think I understand your problem now! You need all the names in the list but you only want to select some of them!

You could make your select something like this:

SELECT IIF(active, '', '\') + name, key etc.

This way all records will show, but inactive records can't be selected.