Two Listboxes

[DS]

I have 2 listboxes based on the same table.
I need the 2nd listbox to show what records are not in the first
listbox. How would I do this?
Thanks
DS

 

[Allen Browne]

What is the RowSource for the first list box?

If it is a simple query from one table, the second list box will be based on
a WHERE clause that picks the alternative records. Don't forget to handle
the Nulls:
http://allenbrowne.com/casu-02.html

If it is a 2-table query, then you might be able to use the Unmatched Query
Wizard to help you get the SQL statement you need for the RowSource of the
2nd list box.

After you get that working, you may need to Requery the other list box when
one changes.

 

[DS]

What is the RowSource for the first list box?

If it is a simple query from one table, the second list box will be based on
a WHERE clause that picks the alternative records. Don't forget to handle
the Nulls:
http://allenbrowne.com/casu-02.html

If it is a 2-table query, then you might be able to use the Unmatched Query
Wizard to help you get the SQL statement you need for the RowSource of the
2nd list box.

After you get that working, you may need to Requery the other list box when
one changes.

Thanks, That is an easy solution!
DS