cascade combo box

[Andyjones]

Hi I wounder if anyone can help with this. a friend of mine manage to create a cascade combo box on the data entry form, it works when you select leage type smethwick or south staffs it then shows in the our team combo box the teams linked to that division, however I have tried to copy the design and use the same setup in the oposition drop down box but it does not work, could someone have a look for me please to get it to work.

i dealy I only want to selet the teams from the table labled leage teams but do not mind if two table for our teams and opposition teams have to be used. Its just this one thing then the databse is ready to go ready for the league that starts next week.
Attached File(s) Langley_B_Player_Stats_and_Averages.zip

[mejia.j88]

can you attach db through this site?
compact and repair db if it is too large, then zip

[Andyjones]

i have compacted and repaired it but cant shrink it anymore than I have its office 2010 and in a zip file il add another link to see if it helps you download it

[Andyjones]

hi Try this I r-saved the database as a different name if this does not work then il copy everything to a new db

[Andyjones]

try this one

[alansidman]

I tried to open the database using AC2007 and was advised it was unrecognizable. You will get more responses if you can save as a version 2003 as many users here are not using 2010 or 2007 yet.

[Andyjones]

try this one please last attempt other than that access 2010 will not allow me to save it as anyother file formate due to the fact it has extra features that access 07 does not