on this form I have three txtboxes one is (the currect date),(orderdate),(duedate)
the orderdate has the date the order was picked up. The due date is set to the date the items must be returned or (one week). The current date is set for when the current date passes the due date it displays a message "past due"...By the way I have made this possible through the control source with this code:
current date code:
Expand|Select|Wrap|Line Numbers
- =IIf([DATEtxt]>[DUEDATE],"PAST DUE! ","NOT DUE YET")
Expand|Select|Wrap|Line Numbers
- Private Sub RETURNEDTXT_Click()
- If RETURNEDTXT = True Then
- Text12.Visible = False
- Text3.Visible = False
- Else
- Text12.Visible = True
- Text3.Visible = True
- End If
- End Sub
or is there another code or if this code is wrong in short HELP!!!!
LEE 123