Sorting to exclude with more than one instance of "x"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to create a combo box that will allow users to pick a year value
from a table and I am trying to limit the choices based on what is in query.

example;

tbl_years has a field with the values 1995 through 2005

a field in a query has the value 2001, and 2003 (or any other
combination/permutation of the above values).

How can I get the combobox to show 1995 through 2005 and exclude the two
values I found in the query? The embedded query in the combobox seems to
error out with more than one "year" in the query.

Is there a better way to do this?

Thanks,
Ken W.
 
Ken,

Make the Row Source of the combobox a query that includes tbl_years and
the query, with a Left Join on the field in question, and Is Null in the
criteria.
 
Back
Top