G
Guest
I have a listbox on a form. The listbox row source is a query. It pulls in
fields such as Work Request ID, Category, Status, Assigned To etc.
On the same form I have an option group with 6 options (Category, Status,
Building, Floor etc). When one of these are selected - it populates a combo
box with the data. For example - if the user selects OptionCategory then the
combo box lists all the Categories to choose from.
Once the user has selected one of the six options and then selects an item
in the combo box - I want to filter the listbox to show only those records.
For example, the user chooses the Option Category and then selects the
category Plumbing from the combobox (cmbFilterBy). The listbox is then
filtered to show only those records where the category is Plumbing.
I know how to filter a report as the next step but I am looking to filter
the listbox and I am not sure how to go about doing this.
Thanks.
fields such as Work Request ID, Category, Status, Assigned To etc.
On the same form I have an option group with 6 options (Category, Status,
Building, Floor etc). When one of these are selected - it populates a combo
box with the data. For example - if the user selects OptionCategory then the
combo box lists all the Categories to choose from.
Once the user has selected one of the six options and then selects an item
in the combo box - I want to filter the listbox to show only those records.
For example, the user chooses the Option Category and then selects the
category Plumbing from the combobox (cmbFilterBy). The listbox is then
filtered to show only those records where the category is Plumbing.
I know how to filter a report as the next step but I am looking to filter
the listbox and I am not sure how to go about doing this.
Thanks.