Property sheet validations

[thisisjess]

I need help with my property sheet validations.
I have three things on one table to give restraints to,
1) Deal end date is on or after the deal start date
2) Cut off date is on or before deal end date
3) return date is on or after the trave date

I have tried
"IsNull" Or (([EndDate]>=[StartDate]) And ([CutDate]<=[EndDate]) And ([ReturnDate]>=[TravelDate]))

This does not seem to be working, is there something more I can do or an alternate method?
Thanks everyone!

[orange]

see this thread
https://www.accessforums.net/access/...ule-54144.html

review the dialog and look at post #12

Also,
It is helpful to readers if you give some overview of your business requirement in plain English. Putting some context around your requirement reduces the guessing by readers.

Don't overlook Google/Bing etc for research.
Good luck.

[ssanfu]

You didn't specify (or give much info), but it sounds like you are trying to add table level validation. I never set validations at the table level.

I would use the form before update event to do the validation. Easier and better control.....