ListBox Deselected Item

[GDub]

I have a List Box set to Simple Multi-Select. As items
are highlighted in the Listbox, a subform is populated
with that item and its details.

I'm looking for a method to remove the item in the subform
that corresponds to the current, individual listbox item
as it is deselected.

ListBox Name = PartList
Form Name = MatTop
Subform Name = MatBottom

Thank You

 

[Michel Walsh]

Hi,



http://www.mvps.org/access/forms/frm0007.htm supplies code for a query where
the selected data could be use as criteria. You would have to change the
criteria for a NOT IN( ... list... ). Send the criteria "FieldName NOT IN
(... list... )" as where clause of the recordsource (or as filter, or
otherwise) to your subform.



Hoping it may help,
Vanderghast, Access MVP