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

22 Feb 2005 11:21 PM

Kinster

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.

--
Kinster
Newbie Access Designer

23 Feb 2005 7:30 AM

Steve Schapel

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.

--
Steve Schapel, Microsoft Access MVP

Kinster wrote:

Show quote

> 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.
>
>
>