Do you have your Link Master/Child fields linked between the 2 forms (select subform control and see data tab on property sheet)? If you do, then you...
1 - Thanks Micron, the parent record of BillID & MainHeaderID is present in the subform. I am trying to avoid entering the BillID & MainHeaderID each...
I think you didn't read my post properly. The table structure where for different school years are different columns doesn't work well (really, this...
If you havce a field that actually defines the school year and perhaps term, like 2021 and 1, then just look for that field being 2021. If you wanted...