Filtering subform results based on unbound listbox selections
Posted on 2008-10-31
There's other similar questions here but don't seem to be either working or exactly what my issue is.
I have multiple unbound (cascading) listboxes on the mainform, and I would like the subform to filter it's results based on the selections in the listboxes. For example:
-lst1 properties = tblAPK; tblADescription (only shows description)
-lst2 properties = tblBPK; tblBDescription (only shows descrition)
I'm not sure if it makes a difference but the lst2 display is filtered by what's selected in lst1.
Subform properties: Details; Dates; Names; tblADesc; tblBPK
So the results on the subform would be filtererd when lst1 was selected to only tblADesc, and further filterd when lst2 was selected to only tblB selction.
Right now the only real "code" I have to speak of is requerying the cascasing lists:
Private Sub lstA_AfterUpdate()