I don't believe it is possible to switch off Intellisense in Access. It isn't wise even if it is possible
If you know better, please tell me how you...
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...