Drop Down Choices

R

Rlittle

Is it possible to have a list in a drop down box from a database function so
that when a choice is made that choice then no longer appears in the list for
the drop down box?

Ex:
Person One
Person two
Person three

I choose Person two.... now in the drop down box you would have...

Person One
Person three

-------person two is no longer there.

?????
Thanks,
Rlittle
 
T

Thomas A. Rowe

Not really, since the database query the populate the dropdown is not aware that an option has been
selected.

Even if you wrote a update query to mark the option as used, what about the next person using the
dropdown or when the list is empty, because all item are marked as used?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Top