Calculated Field Validation

[geet72]

I have a form with three entries. I am creating a calculated field with the sum of these three entries. The calculated field sum should add up to 100. If not, there should be a error message that pops up and the user would not be able to proceed until the three entries are adding up to 100. How can I do this

Regards

 

[pbaldy]

The typical place for validation is the before update event of the form. If data fails validation, you can add this to your code to stop the update:

Cancel = True

 

[geet72]

Thanks. Can you please tell me the code for this. I am a beginner and I am still trying to figure this out

Regards

 

[pbaldy]

Along the lines of:

If Me.CalculatedFieldName <> 100 Then
  Msgbox "Check the amounts"
  Cancel = True
End If