Continuous Form displays Checked Record in main form

[noboffinme]

Hi

I have a db with frm_team with an ID autonumber & 3 unbound fields - Player, Team & Position.

There is a Subform that also has the Player, Team & Position fields & a Checkbox to designate the Captain of the team.

I need the frm_team fields to update to the records from the subform where the Checkbox is ticked.

I've tried several ways to read the records but have run into a couple, of problems;

Any currently checked checkbox needs to automatically uncheck so there's only one checked at a time.

The record should only show the records results from that frm_team ID field.

Any suggests?

database attached - I wonder if my approach is correct also as a Continuous form may be too much trouble to try & automate this - open to any ideas or if anyone has come across this & worked out an answer, Thanks