Need help creating a combo box that filters a list box that I have created below the combo box. I have named the combo box "ComboAllOK". In the list box, I have essentially created a query in the row source in the properties that pulls information from several tables. Also in this query, I have created a field called AllOK using the builder feature:
AllOK: IIf([tblMonthlyReview].[CashReview]='OK' And [tblMonthlyReview].[EquityDriftReview]='OK' And [tblMonthlyReview].[DomesticExposureReview]='OK' And [tblMonthlyReview].[AssetClassDriftReview]='OK','ALL OK','REVIEW')
As you can see, this returns two results: ALL OK or REVIEW. This works exactly as I'd like it to in the List Box. The problem now is using the combo box to filter the list. I want to be able to filter the list to show all of the results (both ALL OK and REVIEW), filter to show only the ALL OK results, and filter to show only the REVIEW results. I've done this before using fields from a Table, but never from the query built withing the row source of the list box.
Any suggestions?
Thanks!