Validating a field (dependent fields) (1 Viewer)

[hazeyw]

I am trying to put in a validation rule so that data in one field cannot be less than that in another.
e.g. i want to make a validation rule so that a phone call end time cannot be before the phone call start time.
Can anyone help???

 

[strep21]

Not in a table.
Use a validation rule in your input form.

 

[hazeyw]

Ok Cheers, will do

Can you suggest the code needed plez

 

[strep21]

I attached a mini-sample.
Good luck

 

[hazeyw]

Thanks very much,

Solved now........Erm any chance you can look at my other query?

Cheers

 

[Pat Hartman]

I didn't look at the example posted by strep21 so please forgive me if this post is unnecessary. The code should be placed in the FORM's BeforeUpdate event, not in the BeforeUpdate event of the second date field as most people are inclined to place it. If the code is placed in the Form's BeforeUpdate event, it won't matter in which order the fields are filled in and it won't matter if the first date is changed after the second date is entered.