Hi,
I am quite new to Access and have just got comfortable with the basics of making forms, queries and reports.
I have a form with two fields in Purpose and Category.
The user puts in numbers into each field.
I would like to put in some code so that if purpose = 1 then category must = 1, or 3. If so, that's fine, if purpose does = 1 but category does not = 1 or 3 I would like a message box to say error.
If purpose...