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

  • Thread starter Thread starter qwerty via AccessMonster.com
  • Start date Start date
Q

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.
 
qwerty via AccessMonster.com said:
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.
Click to expand...

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
 
Thanks! Worked perfectly.

Keith said:
Hi,
Click to expand...
[quoted text clipped - 3 lines]
Thank you very much in advance for our replies.
Click to expand...

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
Click to expand...
 
Back
Top