Validation rule - completion date must be after the start date

[grapevine]

I am trying to create validation in a table to ensure that when the completion date is entered is is either the same as or after the start date.

• I have tried >=[PrStDate] but I cannot save the table
• It will save without the brackets, but I am not sure it is doing the right thing - (sorry no data in to test at the moment)

Can someone please confirm the correct syntax?

[JoeM]

Have a look here: http://www.bluepecantraining.com/por...another-field/

Also note that you can place these types of things in VBA code (the BeforeUpdate event of the field) of your entry Form (users should NEVER have direct access to the underlying tables and should only manually enter data through Forms.

[grapevine]

Thank you for that I have located the property sheet and now I can see the field names as well
Can i just confirm, if i put validation at table level - does it follow through to form and report input as well?
Many thanks

[JoeM]

Can i just confirm, if i put validation at table level - does it follow through to form and report input as well?

Yes. The Table is the "base level", so any rules enacted at the Table level will carry over to Queries and Forms (you cannot do data entry on the Report level, so that really doesn't apply).
Rules are the Form level do not carry over to the Table level (meaning you can get around them by entering data directly into the Table).