Newbie, need help on creating a list box embedded on a form that is filter-able by picking a select

[bkrjeh@twcny.rr.com]

Newbie, need help on creating a list box embedded on a form that is filter-able by picking one of three items from a drop down list on same form

I have a table that has a has multiple items in it with three possible selection by logic yes/no check boxes

I want to have the list box on the form populate when you select either item 1, returns only items that are check with yes on box(column 1)
when you select item 2 , it returns only items that are checked yes on box (column 2)
etc for item 3



any ideas ?

[Micron]

First, take a look a this in case you want to change your approach http://allenbrowne.com/casu-23.html

Otherwise, make a query for the listobx that works if you write in each of the combo box values and test each. Once that's working, change the critera to reference the form combo (=Forms!frmFormName.ComboBox). Open the form, make a combo selection and run the query manually to see if you got that reference correct. If the query returns records for the combo selection as you expect, on the combo box After_Update event, make the listbox rowsource = that query and make the next statement requery the listbox.