G
Guest
Greetings all. I know this is probably very simple, but I could not find the
solution by searching previous posts. In SQL2K and ADP I have tblOrderID
with fields ID(int identity), Job# marchar(50), and OrderDate(smalldatetime).
I have a form with Job# and OrderDate as fields where the user puts in the
required info. Then I have a linked subform where the order specifics are
entered into tblOrderItem. I have made both Job# and OrderDate to be not
null fields, but sometimes users forget to put the date before going to the
subform which causes an error. How do I get the OrderDate field to
automatically show the current date as soon as the Job# field is updated with
a new record? Thank you.
solution by searching previous posts. In SQL2K and ADP I have tblOrderID
with fields ID(int identity), Job# marchar(50), and OrderDate(smalldatetime).
I have a form with Job# and OrderDate as fields where the user puts in the
required info. Then I have a linked subform where the order specifics are
entered into tblOrderItem. I have made both Job# and OrderDate to be not
null fields, but sometimes users forget to put the date before going to the
subform which causes an error. How do I get the OrderDate field to
automatically show the current date as soon as the Job# field is updated with
a new record? Thank you.