validation of two date fields in table

[dd/mm/yy]

hi there

i have two date fields in a table, DateOpened and DateClosed (ordering-type sytem), i need to test DateClosed and ensure that it is greater or equal to the value in DateOpened (i.e. an order is not closed before it is opened).

in the validation rule i put >=[DateOpened] and also tried >=[tblOrders].[DateOpened] but am getting an assortment of errors.

i dont really understand sql or much in the way of deep validation so any help with this would be greatly appreciated.

thanks

dd/mm/yy

 

[Rich]

Use thge Before Update event of the form you're entering your data into.
If Me.txtEnd<=Me.txtStart Then
Cancel = True
MsgBox"You cannot enter an earlier date than the start dumbo, try again!"
End If

 

[dd/mm/yy]

hey thanks a lot for that!

works perfectly!