A very common UI requests I hear from Microsoft Access developers goes something like this:
I have a continuous form with a check box, and only one record should be allowed to have it checked at a time.
Think :
- Primary Phone
- Default Address
- Main Contact
- Preferred Email
- etc.
In a perfect world, we’d just use option buttons. But continuous forms don’t work that way where each record is rendered independently, so Access gives us many check boxes, not one logical group.
So how do we enforce mutual exclusivity?
Let’s walk through this step by step, starting with a straightforward After Update solution and progressively refining it into something cleaner, reusable, and faster. You pick the approach that suits your needs.
Continue reading
