Remove names from list box upon selection

[jamphan]

I have a list box that is filled from a table with names of individuals. What I would like to do is when one of the names is selected it will take it off the list and do this for all the names in the list until all are removed then will reset and have the names avaialble once again. Is this possible and if so how can it be done? Thanks.

 

[KenHigg]

Base the list box on a query that limits the selections...

 

[jamphan]

Can you please expand a little. I am not sure what you mean.

 

[KenHigg]

Build a query that returns the names you whant in the list box. You may have to have two tables in your query. Say, something like show me all names in my master name table that don't have an entry in my secondary table...

Then use this query as the row source in the list box...

???

 

[jamphan]

It's been a long week so forgive me but I am not following. Is this going to take names off as they are selected then refresh when all have been used?

 

[KenHigg]

Sure, you just need to requery on after update or somewhere.