I am pretty new to Access but am feeling pretty confident at what I have accomplished so far. I've run in to a snag, however. I have two check boxes on a form and I want to build a string so that when the Exempt check box is selected it automatically checks the Paid box. HELP!

Put this line in the OnClick Event of the Exempt check box:-

If Me.Exempt Then Me.Paid = True

It worked wonderfully! Thank you!

When you have mutually exclusive values, they should be stored in a single field and represented on a form with an option group if there are onaly a few choices and those choices are unlikely to change or by a combobox if there are many choices or choices are likely to be added.