Combo box not to show previous records already selected

Bhoc

Registered User.
Local time
Tomorrow, 05:15
Joined
Apr 3, 2013
Messages
45
I have a form that has four combo boxes on it that enable the user to select entrants in a golf tournament for tee off times and tee. (I have attached part of this database to this post) It all works fine but after selecting the first player in the first combo box and then selecting the second combo player I would like the player selected previously not to show up. Is this possible or do I have to rethink the way players are selected.
 

Attachments

Try the attached database.
Hmm - maybe I've misunderstand what you want.
 

Attachments

JHB
thanks for that
that works for the first four but after selecting them then tabbing down to select another four it refreshes the list and the names appear again.
 
Yes I thought I had misunderstood what you want.
I've attached a new version, which should work like you want it.
 

Attachments

JHB

That works great exactly what I have been pulling my hair out over for the last couple of weeks thank you
 
You're welcome, luck with your project.
 

Users who are viewing this thread

Back
Top Bottom