MS Access required fields within form

Question

I'm trying to get the following done. I've a form with 7 fields which I want to be required before adding those to the record. The problem is that I use VBA to make every field empty if you change something in a field above. If I set the field as required in the table I always get an error when I'm running the VBA saying that one off the fields is required. Is there a way around this?

Gr. Ralf

Answer 1

Use the BeforeInsert event:

Cancel = IsNull(Me!Field1.Value + Me!Field2.Value + … + Me!Field7.Value)

If Cancel = True Then
    MsgBox "Missing field"
End If