Validation problems...

[dbDamo]

Hi

I am having some difficulty adding some validation rules to a few fields in a form and would be very grateful for any help/advice.

Here is what I am trying to achieve:-

Test Start Date

>= Project Start Date
AND <= Project Finish Date


AND Cannot be Null when Test Status (list box) equals either "In Progress", "Incident" or "Complete"

Planned Completion Date

>= Test Start Date
AND <= Project Finish Date
AND Cannot be Null when Test Start Date Is Not Null

Completion Date

>= Test Start Date
AND Cannot be Null when Test Status (list box) equals "Complete"


I'm ok with ensuring the dates fall within the correct ranges, but I get lost when trying to add the remaining rules. I'm working in Access 2000.

Thanks in advance.

[RuralGuy]

What code do you have that you are having trouble with?