Filter to change a Label

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a command button that performs a filter.
What I'd like it to ALSO do is be able to change the text in a label that
sits in the Header.

My code is:
With Me
.Filter = "[Source] = 'SE Meeting' AND [Status] = 'Open'"
.FilterOn = True
.OrderBy = "[Group_Name], [IssueID]"
.OrderByOn = True
End With

So, when I click the command button it'll filter but I want "Label32" to
change from what it is now to "Systems Engineering"

Is that possible if so, what can I do or is there another approach?

Thanks
Ben
 
Back
Top