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


G

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.
 
Ad

Advertisements

S

SARAH

gigglin''''me said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top