Hi All,
I have a Form frmAuditTrail, it has three combo boxes in the header (Username, Area & Action)
What I'm attempting to do is if an Area is selected then I want the Combo box for Action to only list Actions associated with the Area. The difficulty comes when if no Area is select then I want all actions to be listed in the Action Combo Box.
I have been unsuccessful with:
Please can someone brighter than me suggest an alternative
Many Thanks
Thicko
I have a Form frmAuditTrail, it has three combo boxes in the header (Username, Area & Action)
What I'm attempting to do is if an Area is selected then I want the Combo box for Action to only list Actions associated with the Area. The difficulty comes when if no Area is select then I want all actions to be listed in the Action Combo Box.
I have been unsuccessful with:
Code:
IIf(IsNull([Forms]![frmAuditTrail]![Area]),Like "*",[Forms]![frmAuditTrail]![Area])
Please can someone brighter than me suggest an alternative
Many Thanks
Thicko