I posted this a few weeks back and received an answer, but can't get things to work. Thought I'd try again.

I have set up a database to manage 5-a-side football leagues, this includes contact details for the teams, links to word etc. I have it working at the moment with seperate databases for each League but what I would like to do is have one database and enter all teams and their respective leagues and results.

What I can't sort out is this: when I am entering the results I need to select the relevant league ( there are 6) in combo box 1
and the league I choose will filter the teams in combo box 2 ( there will be up to 60 teams so I don't a great long list to have to choose from).

It would seem an easy one for access but I can't work it out. Any help gratefully received.

Thanks

Russ

[This message has been edited by RussG (edited 03-15-2001).]

You can set combo box2's row source SQL statement to include criteria based on the value selected in combo box1. Then in combo box1's "AfterUpdate" eventput this:
DoCmd.Requery "ComboBox2". I've used this method to cascade six combo boxes on one form. I works well when you need to drill down through a lot of information.