Is it possible to require an entry in a field based on whether another Yes/No field is checked as "Yes".
For example: User adds a new record (using a Form). On the form the User checks Yes for new revision. Therefore several other fields require entry. I can't set the field as required at the table level because entry is only required if it is a new revision.
If NewRevision = Yes Then Field2 Is Not Null .... display MsgBox "Field2 Is Required" User clicks OK - Set Focus on Field2......