Validation of Form based on three fields

[joepineapples]

I have a Form called Demographics.

On this form there are several fields three of which are relevant to my query.

1. Reported
2. Male
3. Female

What I want to be able to do is to check that the total of Male and Female equals Reported. If not then display message box "Error etc".

I would want to activate the validation before the form is closed or it moves to a different record.

I'm guessing this can be done in code but my knowledge is quite limited.

Any help would be much appriciated.

 

[Bat17]

In the forms before update event use something along the lines of

If Nz(Me.Male) + Nz(Me.Female) <> Nz(Me.reported) Then
    MsgBox "Your Error Message", vbCritical
    Cancel = True
End If

HTH

Peter

 

[joepineapples]

Cheers. That works a treat.

JP