Date Validation Rule

[Betibox]

Could somebody advise please ?:( I've got 2 dates in my Booking table StartHire and EndHire I wont the use Not to be able to input in the EndHire column date which is = or<than StartHire. Any clues would be appreciated.
Thanks in advance.
B

[missinglinq]

You should always have your data input into the table done thru a form, and in the code module of the form:

Private Sub Form_BeforeUpdate(Cancel As Integer)
 If Me.EndDate <= Me.StartDate Then
   MsgBox "End Date Must Occur After Start Date!"
   Cancel = True
   Me.EndDate.SetFocus
 End If
End Sub

Welcome to bytes!

Linq ;0)>

[NeoPa]

If you want to specify how two (or more) fields within a table relate to each other you can open the Properties window of a table in Design mode and specify your rule in the Validation Rule property there.

In your case I suspect that you'd want :

[StartHire]<[EndHire]

The Validation Text property can be used to specify an error message if you're not happy with the default one being used.