Try again

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

Guest

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

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
 
Back
Top