Two Listboxes

  • Thread starter Thread starter DS
  • Start date Start date
D

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
 
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.
 
Allen said:
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.
Click to expand...
Thanks, That is an easy solution!
DS
 
Back
Top