I want to use one pull down menu to choose the position of a player on my
team and I want to use the adjacent cell to pick a player in a list of
players playing that position. Is it possible to use the first pull down menu
and the cell value to call a list for the adjacent cell?

Make the second Combo Box's record source a query with the criteria pointing
to the first Combo Box. Use the AfterUpdate event of the first Combo Box to
Requery the second.

Perfect example on Microsoft's KB -
http://support.microsoft.com/kb/98660/en-us

- Jason

"Eric" <(E-Mail Removed)> wrote in message
news:78F77BA0-2167-4357-BA56-(E-Mail Removed)...
>I want to use one pull down menu to choose the position of a player on my
> team and I want to use the adjacent cell to pick a player in a list of
> players playing that position. Is it possible to use the first pull down
> menu
> and the cell value to call a list for the adjacent cell?