value list - row source problem

[timeh]

ok, what i'm trying to do is this:

In a table, i have 4 fields:
team1
team2
team3
team4

each of which contains data type "text"
each is a combo box with 'row source type' set to "value list"
and in the row source itself is the following:

"1st";"2nd";"3rd";"4th"

so a position can be chosen for each team
however, obviously 2 teams can't be in the same position
so i want to make it so that once a position e.g. "1st" has been chosen for a team, it cannot be selected for another team, i.e. 2 positions cannot be applied to the same team.

- this probably seems very simple to most of you, but i am a beginner, and any help would be much appreciated

 

[Fizzio]

There are 2 ways I can suggest that you can try.

Depending on how your form is structured you could either

a) check by code that the previous value has not been chosen
b) remove that value from the next combo box value list by code

I feel (a) would be easier but (b) may be more efficient. I cannot offer any code at the minute but I'll try to knock something up for you if no-one comes forward with a solution.

 

[timeh]

thanks a lot , an idea of the code would be useful, i'm gonna try and learn a bit of vb this summer but at the moment i have next to no programming ability

 

[Fizzio]

Try this. It's a little but rushed with no error trapping in it but it may give you some more insight / ideas.

 

[timeh]

fizzo mate that's great, hehe, cheers
if there's nethin i can do that u need help with....er...thats not really very likely is it..hehe thanks neway