My users are required to enter records for 15 predefined equipment records daily. I have included 15 unbound labels with these equipment numbers on the form. As a record is entered for todays date and saved I would like the appropriate label (label186) to change from red to green.
This will provide an easy method to ensure all equipment record have had entry every day, and the reports will contain "all" the data.
Table: SOFTCOUNT
INSERTDATE (date/time)
TABLENUM (text)
I tried the following with no luck.
The following day they would all appear red again until a record is entered for todays date.
It's a never ending learning cycle.........
Cheers,
This will provide an easy method to ensure all equipment record have had entry every day, and the reports will contain "all" the data.
Table: SOFTCOUNT
INSERTDATE (date/time)
TABLENUM (text)
I tried the following with no luck.
Code:
If (DLookup("TABLENUM", "SOFTCOUNT", "TABLENUM=" & Me!TABLENUM)) Then
me.label186.forecolor = 25600
End If
The following day they would all appear red again until a record is entered for todays date.
It's a never ending learning cycle.........
Cheers,