If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
set overdue display in header from date in sub
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. |
Thread Tools | |
Display Modes | |
|
|