Validation Error

[ICTkirsten]

Hello,

ive got a subform and in it ive put validation IsNull(Front)
validation text : please enter front

and another : IsNull(Back)
Validation text: please enter back


wierd thing is when i enter front i get the error msg please enter front...

and when i press the save button when i dont enter any values im not alerted..

does anybody know whats going on here?

 

[Trevor G]

Can you upload an extract of the database with the form and then someone will take a look for you.

 

[CJ_London]

when i press the save button when i dont enter any values im not alerted

validation rules are only applied when a user enters the control - if the don't enter, the rule is not triggered. If you want to make sure a suer completes a field, in the table design you should set it's required property to yes.

Alternatively have some code in the form before update event to check the control has been completed

Your rule does not make sense - you are saying the value must be isnull(front) - which means the user should not enter anything.