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




Nikos Yannacopoulos


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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question