I set up a form with subform. The main form has a combo box to select a players name. The subform then shows the detail of cautions for that player. I had this working nicely but them wanted to filter the players by 2 other combo boxes. combo 1 selects a league, which filters combo 2 to select a team, this then filters the players for that team. I have the combo filters working but the subform haslost its link.

Any ideas what I'm doing wrong?

Thanks in advance.

Russ

Yes you had the subform linked to the first combo box and now you need it to be the third combo box.

If it is a sub form I am assuming you made a query to base that form on. It will probably have a criteria being the first combo box - you need to change that to be the third combo box.

Then you will need a requery statement for the subform on the AfterUpdate event of the third combo box

HTH