Dropdown Selections

[Scott Heslop]

Hi,

I have a 20 filtered dropdown selections, but you can only see 1 at a time. So once you fill in the 1st dropdown the other appears to select what name you want.

I need to know, if say Joe Bloggs was selected in the first dropdown, i dont want him to appear in the second dropdown or any dropdown and what ever is selected in the 3rd i dont want appearing in any other etc. As i am booking people onto courses so i dont want to be able to select the same person twice for the same course.

I can but error messages in but i just want the user to be able NOT to pick that name.

Any suggestions will do.

 

[edtab]

You need to filter out whatever has been selected in the prior dropdowns.
You can do that in the query which you are using as the record source of
your succeeding dropdown(s). You need to do that for all the dropdowns except
the first one which will have all the names available to you.

 

[Scott Heslop]

And how would i do that?