How to exclude the records of a table based on a ListBox?

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
Frank,

Your question is too general to have a single answer. How do you mean
"exclude"? Where from? Is your listbox a single or multiple selection one?
For example, if you need this for a query criterion, single selection
listbox, you would use something like:
<> Forms!FormName!ListBoxName
in the query criteria line.
If it's for a form / subform recordsource, you would need a few lines of
code to apply a filter or redefine the recordsource.
If it's a multiple selection listbox, you would need some more code to scan
the listbox and get all the values to be excluded etc.

HTH,
Nikos
 
Back
Top