Good day.
I've been struggling with this for a while.
I have a subform (subfrmPlayerStats) which includes a combobox (called [Team]) with two columns (NHLTeam in one column, and their respective AHLTeam in the second).
The record source for this subform is called "qryPlayerStats". In this query, there are three tables:
There is a checkbox in the main form (frmPlayerStats) called [Minors].
What I want to do is when I check the box, the combobox will store column 2, and when unchecked, it will store column 1.
Any help is greatly appreciated.