set overdue display in header from date in sub

[Dale G]

My form frmUniformOrders has a sub form frmUniformTrans.

frmUniformOrders is set to tblUniformOders and places the OrderID, and EmpNo
in the table.

frmUniformTrans is set to tblUniformTrans, and the controls are set to these
fields.

OrderID, TransID, ArticleID, Size, Quantity, DateOrdered, DateReceived,
Status, SupplierID.

I’m trying to set a time factor on the main form, for orders that have not
been received for over 60 days.

I would like a message to display in the header of the main form that would
show “Overdueâ€, and not display if the order was received within 60 days, and
stop the display when the order is received.

As you can see my date ordered, and date received are in the sub.

I did place a text box on the main form and a field in tblUniformOrders
named DueDate, and a text box in the header with,

=IIf([DueDate] < Date(), "Overdue", Null).


Then I would calculate 60 days and place it in the DueDate box, but this
doesn’t stop the display, and it doesn’t seem to be necessary to have the
due date field.

Does anyone know a way I can achieve this? Hopefully without code.

I'm using Access 2007. Any info is appreciated.