murray83
Games Collector
- Local time
- Today, 10:29
- Joined
- Mar 31, 2017
- Messages
- 736
I have a report ( hence posting in the report section ) which is populated from a query which is all fine and dandy
but now as with all things need to add to it which is fine, but it wont work as required due to the report at some point having in the Area Header a value of To Do, is there someway i can loop it. The other values are as follows
code is below and as you can see i only want them to appear when it has To Do
cheers all
but now as with all things need to add to it which is fine, but it wont work as required due to the report at some point having in the Area Header a value of To Do, is there someway i can loop it. The other values are as follows
- General
- Sick
- Helpdesk
- HBW
code is below and as you can see i only want them to appear when it has To Do
cheers all
Code:
If Me.txtArea.Value = "To Do" Then
Me.lblRaisedBy.Visible = True
Me.lblClosedBy.Visible = True
Me.txtClosedBy.Visible = True
Else
Me.lblRaisedBy.Visible = False
Me.lblClosedBy.Visible = False
Me.txtClosedBy.Visible = False
End If