Subform values/datasheet based on a listbox(multiple selection) on main form
Posted on 2006-05-18
It seems this should be easy but I can't seem to do it...
I have a main form that is not based on a table. On it I have a list box to select multiple categories. Source for that is a select distinct categories based on a combo box. That list comes from a table called Expanded. subform is based on table Expanded. All I want to do is have the subform display the data where user selected from the list box (list box is defined as multiple). I wrote code attached to a button that gets the ItemsSelected in the listbox and creates a where clause. I don't want to DoCmd.OpenForm (djfskldfjsl, whereclause) because it opens another window with that form in it.
I want the subform to display the data. These forms are not linked because parent isn't based on a table. It's just a "selection" form.