Combo box to only list choices that are not in the table

[qwerty via AccessMonster.com]

Hi,

How can I get a combo box to only display choices that are still not in the
table (control source)??

Thank you very much in advance for our replies.

 

[Keith Wilby]

Hi,

How can I get a combo box to only display choices that are still not in
the
table (control source)??

Thank you very much in advance for our replies.

Do you mean your combo box row source is a lookup table and the choice is
stored in a main table and is the combo's control source? If so then create
a query with a "not in" clause in the criteria as the combo's row source
(untested):

Select [MyField] from tblLookup where [MyField] Not In (Select [MyField]
from tblMain)

HTH - Keith.
www.keithwilby.com

 

[Miguel Alexandre via AccessMonster.com]

Thanks! Worked perfectly.

Hi,

[quoted text clipped - 3 lines]

Thank you very much in advance for our replies.

Do you mean your combo box row source is a lookup table and the choice is
stored in a main table and is the combo's control source? If so then create
a query with a "not in" clause in the criteria as the combo's row source
(untested):

Select [MyField] from tblLookup where [MyField] Not In (Select [MyField]
from tblMain)

HTH - Keith.
www.keithwilby.com