Filter Listbox Using label Box

[wrweaver]

I'm trying to create an on click event for a label where when i click it, it will only show records in the list box that have a particular station name. The listbox get it's info from a query. The StationName is a text field in one of those tables that is in the query. Here is the rowsource for the listbox.

SELECT WorkOrderID, DateRequested, IsScheduled, DateCompleted, Description, DomainName, StationName, BuildingName, EntityNumber, BuildingNumber, PriorityDescription, StatusDescription, StatusOrder FROM WorkOrderQ ORDER BY DateRequested;

Can anyone help? Thanks!

 

[pbaldy]

In the click event, set the row source property of the list box to similar SQL but with your criteria.

Me.ListboxName.RowSource = "SELECT...WHERE FieldName = 'ABC'"