Try again

[Alvin Hansen]

Hi!
I have a combox there show all Movies I have
In the same form i have a listbox there show all actors there are in the
selected movie from the combobox - this works allright.
But then i have a second combobox there show me all actors
so i can get the movie a new actor, so far so good - now i want that
this second combobox show me all actors but not the actors there all ready
are in the movie........ So the combobox shall show me all actors but not the
actors there
are in my listbox, i have try many things but ..........................
Please can someone help here

Best regards
Alvin

 

[John Vinson]

Hi!
I have a combox there show all Movies I have
In the same form i have a listbox there show all actors there are in the
selected movie from the combobox - this works allright.
But then i have a second combobox there show me all actors
so i can get the movie a new actor, so far so good - now i want that
this second combobox show me all actors but not the actors there all ready
are in the movie........ So the combobox shall show me all actors but not the
actors there
are in my listbox, i have try many things but ..........................
Please can someone help here

Without knowing your table structure, I'll have to guess here, but try
a NOT IN query: Base the combo on a query

SELECT ActorID, ActorName
FROM Actors
WHERE ActorID NOT IN(SELECT ActorID FROM Cast WHERE Cast.MovieID =
Forms!YourForm!MovieID);


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps