Subform date/time must be greater than date/time of last record

[gigglin''''me]

I need to prevent users from entering a date & time =< the date & time
entered in the last record on the subform. The subform (Status table) is in
the main form (Customer table). The subform is in datasheet view with fields
CustomerID, Status, StatusDate, and User. The CustomerID is linked to the
main form Customer table, CustomerID.

The user enters the current status and date & time on the subform. The
status field is a combo box. How do I lookup the date & time of the last
record and if the user enters a date & time =< that date, have a message pop
up that the "Date & time entered must be greater than [StatusDate]" (of last
record)?

Your help is much appreciated.

 

[SARAH]

I need to prevent users from entering a date & time =< the date & time
entered in the last record on the subform. The subform (Status table) is
in
the main form (Customer table). The subform is in datasheet view with
fields
CustomerID, Status, StatusDate, and User. The CustomerID is linked to the
main form Customer table, CustomerID.

The user enters the current status and date & time on the subform. The
status field is a combo box. How do I lookup the date & time of the last
record and if the user enters a date & time =< that date, have a message
pop kkjkkkko;lji
up that the "Date & time entered must be greater than [StatusDate]" (of
last
record)?

Your help is much appreciated.