Subform problem (1 Viewer)

[RussG]

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

 

[DES]

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