Validation Help

[pam_w_85]

Hello,

I am currently making a system for a sports centre and I need some help, I have created several forms one of which is for the coach's details.
On the coaches table we have a combo box which has all the different qualifications in it, we have 5 of these boxes but we want to it so that when one has been entered it cannot be repeated in the other boxes, also we want it so that when level 4 Tennis has been entered - levels 3,2 and 1 cannot be entered.

Any help on this would be great,

Pam

 

[pam_w_85]

Thanks,

I looked through all of the threads and some really helped but think I've managed to confuse myself even more!
Can you advise if there is any way to prevent the user repeating data. For example if Tennis Grade1 is entered in one combo box it cannot be selected in any of the other combo boxes?

Pam

 

[Sergeant]

Perhaps this will help...
In combobox2, in the row source...bring up the query builder and put criteria under the field:
<> forms!myform!combobox1
In combobox3, use:
<> forms!myform!combobox1 and <> forms!myform!combobox2

Don't forget to requery subsequent comboboxes in the afterupdate event of the first two.