Limit combo box selection to field on form. (1 Viewer)

[statsman]

I have a form for a sports league to update the player stats.

In the form header I have the team name in a text box. In the detail section I have a combo box to list the players. The form is set to data entry. The user selects via a combo box those players who have a goal or other record from the match and enters this into the form.

I would like to limit the names available in the combo box to just those players on the team that is in the text box. I have tried several approaches but none seem to work. Any suggestions gratefully accepted.

 

[John Big Booty]

Have you tried populating the Combo using a Query that has the Team Name/ID as criteria?