Validating two fields against each other

[benny7]

I have a table which holds a number of fields, one of these being password, and one being password hint. I do not want the operator to be allowed to put their password in the password hint box. Is there a way I can use the validation rule to check passwordhint does not equal password??


Thanks

 

[PHV]

Not at the table level but in a form without problem.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[benny7]

How do you do it then? Please

 

[PHV]

Usually the best place to enforce validation rules is the BeforeUpdate event procedure of the form as we can play with the Cancel parameter and the UnDo method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244