>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.
Right! The problem seems to be that I was doing that in a RowSourceType of 3 (SQL) and it didn't seem to work. I still don't know if I was doing something wrong or it only works with certain Types.
***************************
Bruce Gilmour
"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein