Cascading in Fantasy Footy project

[Ramsjammin]

Hey people

Im really struggling with my AS project for skool and really some help from sonmeone im desperate at the mo lol.

I'm designing an AS project on the Irish Premier league and need 2 cascade the four defender boxes together so that if the user selects one player they cant select the same player in the other boxes. I have created the combo using queries which are all included in my sample database attached to this thread.

Thx Ramsjammin

 

[ColinEssex]

did you search the forum for examples of Cascading ComboBoxes?

Col

 

[Ramsjammin]

Yea I did wasnt that helpful do u no how its done?

 

[ColinEssex]

Try here

Col

 

[Ramsjammin]

Thats were I looked but I didnt understand how 2 implement it into my system

 

[Benny1973]

I have a similar problem

If you look at the demo database it show 2 combo boxes. I need a sub report form to show the selection made but then to show lots of these selections in the sub report based on that record, are there any examples of this because the ones I've looked at on here only show one selection made